Microvellum Community

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!

    Toolbox BSB Survey



    Have you been using Toolbox BSB? We'd love to hear what you think!

    Take the Survey

      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:

                 

          ERP for Millwork Shops


          Discover how Microvellum and INNERGY streamline operations for cabinet shops and millwork manufacturers.