Forum Discussion

Claudia Dubaldi's avatar
Claudia Dubaldi
Copper Contributor
May 31, 2018

Help Needed on Nested IF statements

This is what I entered in the cell:

=IF(C27="NOT APPLICABLE",0,IF(C27="LOW",1),IF(C27="MODERATE",2),IF(C27="SIGNIFICANT",3))

Received message:  "You've entered too many arguments for this function."  I was directed to the Insert Function icon but that was not helpful. Is there a limit?  Did I misplace my commas?  Were the parentheses misplaced, not enough, too many?  A straightforward answer would be helpful. I don't have the time to search for what may or may not address my concern.  I appreciate your assistance folks. - Claudia

Formulas & Functions
training

1 Reply

Sort By
  • Haytham Amairah's avatar
    Haytham Amairah
    Silver Contributor
    May 31, 2018

    Hi,

     

    You have to close each IF's parenthesis at the end of the formula as follows:

    =IF(C27="NOT APPLICABLE",0,IF(C27="LOW",1,IF(C27="MODERATE",2,IF(C27="SIGNIFICANT",3,""))))

    This syntax is known as (Nested IF).

     

    Regards

    Haytham

Resources