Microvellum Knowledge Network

Face Frame (Multi Bay) Subassembly Qty Formulas are Slightly Off

There isn't really anything too broken, its just asking for
=IF(Bay_1_Face_Options<>"No Doors",1,0)

While it should be asking for
=IF(Bay_1_Face_Options="No Door",0,1)

The No Doors causes a problem because F Table is giving the drop down selection as No Door.  All the bays are asking the same.  I just copied an example from Frameless vs Frame

Bay 2 example
=IF(OR(Bay_2_Face_Options="No Door",Bay_Qty<2),0,1)
vs
=IF(AND(Bay_2_Face_Options<>"No Doors",Bay_Qty>1),1,0)

etc.

All it does is gives Component No Door FF (Doesn't exist) a quantity of 1 instead of 0.

Thanks,

-James

    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