contestada

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,A3*135%,IF(A3>500,A3*110%,IF(A3<100,A3*90%,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.

Respuesta :

Parrain

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)))

Otras preguntas