Complex Nested If OR function help

Hi - Trying to build a complex IF/OR function statement for multiple conditions. Right now, I am working around it with a 3-step process, but I need to add another condition and ultimately nest ever...

excel

Formulas and Functions

office 365

HansVogelaar
Dec 18, 2021
JediChristine

IF($AE155>500000,"Required", IF(AND($AE155>250000, OR($AH155="yes", $AI155="yes", $AJ155="yes", $AL155="Comply")), "Required", "Below Threshold"))

HansVogelaar

MVP

Dec 18, 2021

JediChristine

IF($AE155>500000,"Required", IF(AND($AE155>250000, OR($AH155="yes", $AI155="yes", $AJ155="yes", $AL155="Comply")), "Required", "Below Threshold"))

JediChristine
Copper Contributor
Dec 18, 2021
thank you so much! it worked beautifully.

Forum Discussion

Complex Nested If OR function help

Resources