Which of the following formulas MS-Excel 2016 will not be able to calculate? =SUM (AI: A5)*.5, =SUM (Sales)-A3, =SUM( AI: A5)/(10-10), =SUM(AI:A5)-10

Which of the following formulas MS-Excel 2016 will not be able to calculate? =SUM (AI: A5)*.5, =SUM (Sales)-A3, =SUM( AI: A5)/(10-10), =SUM(AI:A5)-10

Explanation

=SUM(A1:A5)/(10-10) is not calculated in excel because 10-10 is zero so something divided by zero is not defined in the excel function.

***

ND18-1-2023

****

RY17-012-23