Forum Discussion
Solved
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...
IF($AE155>500000,"Required", IF(AND($AE155>250000, OR($AH155="yes", $AI155="yes", $AJ155="yes", $AL155="Comply")), "Required", "Below Threshold"))
IF($AE155>500000,"Required", IF(AND($AE155>250000, OR($AH155="yes", $AI155="yes", $AJ155="yes", $AL155="Comply")), "Required", "Below Threshold"))
thank you so much! it worked beautifully.