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

excel

Formulas and Functions

OliverScheurich
Mar 08, 2023
NE-WS
=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?

OliverScheurich

Gold Contributor

Mar 08, 2023

NE-WS

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

NE-WS
Copper Contributor
Mar 08, 2023
This was PERFECT - thank you so much!!

Forum Discussion

Help with a Nested IF/OR Formula

Resources