Search code examples
excelif-statementexcel-formulaworksheet-function

Excel 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?

Solution

  • Please try: 

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