Respuesta :

MrRoyal

Answer:

=(J8 - SUM(D17:D20))

Explanation:

Required

Add D17 to D20

Subtract the result from J8

Save the result in K8

To do this, we make use of a nested bracket.

The innermost bracket is to add up D17 To D20 using the sum function.

i.e. SUM(D17:D20)

While the outermost bracket will subtract the calculated sum from J8.

=(J8 - SUM(D17:D20))

The SUM function is used to Adds values, in which users can add different values, in cells or range references or a mix of each of them, and the further calculation can be defined as follows:

In this question, we use the "=(J8 - SUM(D17:D20))" function that's description can be defined as follows:

  • D17 to D20 Add
  • Subtract the J8 result
  • Save K8 results
  • We use a nested bracket to do this.
  • D17-D20 is added to the innermost bracket with the sum function.
  • SUM, i.e. (D17:D20)
  • The calculated amount from J8 is taken from the outermost bracket.

Therefore the final answer is "=(J8 - SUM(D17:D20))".

Learn more:

brainly.com/question/24245