Aditi wants Excel to calculate the average of cells A1 to A5 only if their total sum is greater than 100, otherwise display Low.…

Question

Aditi wants Excel to calculate the average of cells A1 to A5 only if their total sum is greater than 100, otherwise display Low. She writes: =IF((SUM(A1:A5)100,(AVERAGE(A1:A5),Low))). Is this formula correct?

1. A. Yes, it will work correctly
2. B. Yes, but it works only with integers
3. C. No, it will not work because of a syntax issue (Correct answer)
4. D. No, it will not work because of incorrect logic

Correct Answer

Option C — No, it will not work because of a syntax issue

Detailed Solution & Explanation

The correct answer is No, it will not work because of a syntax issue.

Key Points

• The formula has a syntax error - extra parentheses.
• Correct syntax: =IF(SUM(A1:A5)>100,AVERAGE(A1:A5),Low).