Hi
Cut down C8
Single door C12
Double door C14
Sidelite 1 C16
Sidelite 2 C18
Depending on the size of the door P5: P6 is full glass.
What I need is this:
IF C8 = TRUE AND C12 = TRUE THEN D8
IF C8 = TRUE, C12 = TRUE, C16 = TRUE THEN D8*2
IF C8 = TRUE, C12 = TRUE, C16 = TRUE, C18 = TRUE THEN D8*3
IF C8 = TRUE, C14 = TRUE THEN D8*2
IF C8 =TRUE, C14 = TRUE, C16 = TRUE, C18 = TRUE THEN D8*4
Now if full glass is selected then:
IF C8 = TRUE, IF(OR (P5=TRUE,P6=TRUE), C12 =TRUE THEN D8
IF C8 = TRUE, IF(OR (P5=TRUE,P6=TRUE), C12 = TRUE, C16 =TRUE THEN D8
IF C8 = TRUE, IF(OR (P5=TRUE,P6=TRUE), C12=TRUE, C16 = TRUE, C18 =TRUE THEN D8
IF C8 = TRUE, IF(OR (P5=TRUE,P6=TRUE), C14 = TRUE THEN D8*2
IF C8 = TRUE, IF(OR (P5=TRUE,P6=TRUE),C14 = TRUE, C16 = TRUE, C18 =TRUE THEN D8*2
Bookmarks