Celia is typing a nested IF function to multiply a cell's value by different percentages depending on the cell's specific value. However, the function is not working properly. IF(A3>750,A3135%,IF(A3>500,A3110%,IF(A3<100,A390%,A3) What is the most likely reason why Excel is not recognizing this nested function? Celia should have used colons instead of commas. The symbol is not recognized in Microsoft Excel. Celia did not use enough parentheses. Percentages must be written as decimals.

Question

contestada

Respuesta :

Parrain Parrain · Answer 1 · 2020-05-09T05:00:07+02:00

Answer: Celia did not use enough parentheses

Explanation:

For the Nested IF function to be recognized, a certain amount of Parenthesis should be used to cater for the parentheses used inside the function.

In this case Celia should have used 3 parentheses at the last parentheses to close off the inside parentheses such that the function looks like,

=IF(A3>750,A3*135%,IF(A3>500,A3*110%,IF(A3<100,A3*90%,A3)))

Answer Link