• Call Us : 03082533000 (WhatsApp)
  • Email Us : TestPoint.pk@gmail.com
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
  1. =SUM (AI: A5)*.5
  2. =SUM (Sales)-A3
  3. =SUM( AI: A5)/(10-10)
  4. =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 *

All Rights Reserved © TestPoint.pk