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