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
=IF(OR(LEFT(L!SO_SFLOOR_MODEL,5)="BCDRT",LEFT(L!SO_SFLOOR_MODEL,6)="3DBWAR",AND(SO_END_R_CHOICE="NONE")),1,0
Topic Participants
Mike Flannery
Lenny Scianna
Michael
Christian Pemberton
Richard Laycock
Toolbox BSB Survey
Have you been using Toolbox BSB? We'd love to hear what you think!
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: