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