Nested IF using OR - Getting an #INCORRECT ARGUMENT SET message

BarbaraHanville

Hello!

I have a column with a multiple drop down box (Employment Type). Based on the value chosen, I want to fill in the value in another column (Utilization Target). I have the following formula in the Utilization Target cell, and am getting an #Incorrect Argument Set message. Would appreciate any clues as to where the problem is.

There are two drop down values where I want the result to be 'N/A' and then four drop down values where the result should be '85'.

=IF(OR([Employment Type]@row = "Contractor India Billable", [Employment Type]@row = "Contractor USA Billable"), "N/A", IF([Employment Type]@row = "Full Time India Billable", [Employment Type]@row = "Full Time India Non Billable", [Employment Type]@row = "Full Time USA Billable", [Employment Type]@row = "Full Time USA Non Billable"), 85)

Thanks! Barbara

Rich Coles

You're very close!

Try this formula in the Target Utilization column: =IF(OR([Employment Type]@row = "Full Time India Billable", [Employment Type]@row = "Full Time India Non Billable", [Employment Type]@row = "Full Time USA Billable", [Employment Type]@row = "Full Time USA Non Billable"), 85, "N/A")