Microvellum Community

IF AND Statment

Hi,

I'm trying to create and IF AND statement but I don't know how to word it properly for the formula to work.

If I have the add substrate prompt checked then I want the product to add the substrate. Then further if the substrate is checked I want microvellum to read the second portion of the formula.

Below is the formula but it does not work.

=IF(Add_Substrate=1,1,0),IF(AND(Width>Max_Substrate_Width=1,1,0))

Any help will be great,
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.