SOLVED

# Help with a Nested IF/OR Formula

Copper Contributor

# Help with a Nested IF/OR Formula

Hello!

I'm trying to build a formula that does the following:

If AG="Billable" then return AG -OR-
If AG="Not Billable" then UNBILLABLE -OR-
If AF="Unspecified Coverage" AND AB <> "Weak Match" then UNBILLABLE
If none of above are true, then VLOOKUP Against Excluded Payers and return value

I've managed to get the formula to function as expected for all except the first condition - here is what I've created:

=IF(OR(AG20="Not Billable",AND(AF20="Unspecified Coverage",AB20<>"Weak Match")),"Unbillable",IFERROR(VLOOKUP(AD20,'Excluded Payers'!A:C, 3, FALSE),AB20))

I'm not able to figure out how to modify the formula to consider the first condition.

Any assistance is appreciated!

Nate

2 Replies
best response confirmed by NE-WS (Copper Contributor)
Solution

# Re: Help with a Nested IF/OR Formula

=IF(AG20="Billable",AG20,IF(OR(AG20="Not Billable",AND(AF20="Unspecified Coverage",AB20<>"Weak Match")),"Unbillable",IFERROR(VLOOKUP(AD20,'Excluded Payers'!A:C, 3, FALSE),AB20)))

Does this return the expected result?

# Re: Help with a Nested IF/OR Formula

This was PERFECT - thank you so much!!
1 best response

Accepted Solutions
best response confirmed by NE-WS (Copper Contributor)
Solution

# Re: Help with a Nested IF/OR Formula

=IF(AG20="Billable",AG20,IF(OR(AG20="Not Billable",AND(AF20="Unspecified Coverage",AB20<>"Weak Match")),"Unbillable",IFERROR(VLOOKUP(AD20,'Excluded Payers'!A:C, 3, FALSE),AB20)))

Does this return the expected result?