?
Which of the following formulas will Excel not be able to calculate?
Answer & Solution
Correct Answer:
Option
A
SUM function returns the sum of values supplied. These values can be numbers, cell references, ranges, arrays, and constants, in any combination. Here =SUM(Sales) is incorrect if it is not name of any range.
Join the Discussion
Login to post a comment or share your explanation.
Login=SUM(A1:A5)/(10−10) because it involves division by zero, which is undefined and will result in an error message in Excel.
How this will get calculated, as getting divide by 0.