Forum Discussion

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

Formulas & Functions

training

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