Microvellum Knowledge Network

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.


      Follow us on:

               

        Google Review