Question discussion

Which of the following formulas will Excel not be able to calculate ?

2889Medium DSSSB TGT Computer Science 0 replies 2 views
0

Which of the following formulas will Excel not be able to calculate ?

  • A= SUM(Sales) – A3
  • B= SUM(A1 : A5)*.5
  • C= SUM(A1 : A5)/(10 – 10)
  • D= SUM(A1 : A5) – 10
Correct answer: C

Explanation

(10 – 10) is zero, so the formula divides by zero and returns #DIV/0!.

Discussion 0

Nobody has replied yet. Start the discussion!