0Which of the following formulas will Excel not be able to calculate ?A= SUM(Sales) – A3B= SUM(A1 : A5)*.5C= 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!. Join the discussion Report an error Share