Microvellum Community

Formula

How would I go about adding this formula:

IF(OR(Left_Fin_End=1,Right_Fin_End=1),-.5,"")

To this formula: 

=IF(Bulge=0,Front_Build_Up_Length,IF(Bulge>1,PANELLENGTH_2,IF(Bulge<-1,PANELLENGTH_2,Front_Buildup_Length_Calc)))


Basically I am trying to come up with a formula that if the left or right finished ends are selected in product prompts, the buildup for the countertop will decrease by .5 for each side, sometimes both.  

    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.