vendredi 3 avril 2015

Nested IF statement with various text conditions

I am creating IF statements in Excel to budget according to the discipline of engineers. I want:



IF(H5="CIVIL") then print for me value (I5*5000)
IF(H5="ARCHITECT") then print for me value (I5*3000)
IF(H5="ELECTRIC") then print for me value (I5*3000)
IF(H5="MECHANIC") then print for me value (I5*2000)


I am using a nested IF statement:



=IF(H5="CIVIL",I5,I5*5000,IF(H5="ARCHITECT",I5,I5*3000,IF(H5="ELECTRIC",I5,I5*3000,IF(H5="MECHANIC",I5,I5*2000))))


but I see the message "You've entered too many arguments for this function".


How can I use the formula without any problem?


Aucun commentaire:

Enregistrer un commentaire