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")

heyjay

Missing OR function/operator after your second IF function.

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

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, ""))

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")

heyjay

Missing OR function/operator after your second IF function.

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

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, ""))

BarbaraHanville

@rich Coles - Thanks for the solution - shorter formula! Thanks @heyjay for finding my mistake!

Rich Coles

Glad we could help!