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

Question

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

Quintessence Classes · Accepted Answer

The correct answer is No, it will not work because of a syntax issue. Aditi's logic is actually correct, but Excel will throw a formula error because her syntax is completely broken.The structure of an IF statement in Excel must strictly follow this format:=IF(logical_test, value_if_true, value_if_false)Here are the specific syntax mistakes in her formula =IF((SUM(A1:A5) 100.(AVERAGE(A1:A5), "Low" ))):Missing Comparison Operator: There is no > (greater than) symbol between SUM(A1:A5) and 100.Incorrect Separators: She used a period (.) instead of a comma (,) after 100.Mismatched Parentheses: The parentheses around AVERAGE and the overall statement are misplaced and unclosed properly.How the formula should look:To make this work perfectly, Aditi should write the formula like this:=IF(SUM(A1:A5) > 100, AVERAGE(A1:A5), "Low")

Answer

Yes, it will work correctly for all values

Answer

Yes, but it works only with integers

Answer

No, it will not work because of incorrect logic

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

Answer & Explanation

About this question

JKSSB Laboratory Attendant 2026

Details

More Computer questions

Practice 1,596+ more PYQs interactively