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
- =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
Comments
Leave a Reply
Your email address will not be published. Required fields are marked *