Microvellum Knowledge Network

How to modify this formula?

I want to modify this original formula, which sets a Toekick recess.

=IF(AND(Flush_Toekick=1,Toekick_Back=0),0,IF(Toekick_Drawer=1,G!Toe_Kick_Drawer_Back_Set,G!Base_Assembly_Back_Set))

I want it to include, if the model name starts with either "H" or "2H", then use "G!Handicap_Base_Assembly_Back_Set" otherwise G!Base_Assembly_Back_Set
Wasn't sure how to add that in.
Thanks!

    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