Help with IF, OR, AND formula.
Would anyone be able to tell me what I am missing for the formula to work. It seems ok to the true result. But the false is blank. Guessing I have a comma or parenthesis in the wrong location?
=IF(OR(LEFT(L!SO_SFLOOR_MODEL,5)="BCDRT",LEFT(L!SO_SFLOOR_MODEL,6)="3DBWAR",AND(SO_END_R_CHOICE="NONE")),1,0
MVU eLearning
Grow Your Knowledge
Follow along with RJ as he takes you on a journey to build your foundational knowledge of Toolbox.