Ask Question
12 January, 00:36

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.

+1
Answers (1)
  1. 12 January, 02:42
    0
    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)))
Know the Answer?
Not Sure About the Answer?
Get an answer to your question ✅ “Celia is typing a nested IF function to multiply a cell's value by different percentages depending on the cell's specific value. However, ...” in 📙 Business if there is no answer or all answers are wrong, use a search bar and try to find the answer among similar questions.
Search for Other Answers