hi all hope some one can help has been a while since i have played with these but am having probs
hope someone can help...please
=IF(STD_DW_CAB!DRAW_QTY=1,STD_DW_CAB!LenZ-STD_DW_CAB!DOOR_T_GP,IF(STD_DW_CAB!DRAW_QTY=2,IF(STD_DW_CAB!DRAW_HT_2=16,STD_DW_CAB!LenZ-STD_DW_CAB!DOOR_T_GP-DRAW_2!LenZ-0.15,IF(STD_DW_CAB!DRAW_HT_2=1,(STD_DW_CAB!LenZ-STD_DW_CAB!DOOR_T_GP)/2-0.15,IF(STD_DW_CAB!DRAW_QTY=3,STD_DW_CAB!LenZ-STD_DW_CAB!DOOR_T_GP-(DRAW_2!LenZ+DRAW_3!LenZ)-0.3,IF(STD_DW_CAB!DRAW_QTY=4,STD_DW_CAB!LenZ-STD_DW_CAB!DOOR_T_GP-(DRAW_2!LenZ+DRAW_3!LenZ+DRAW_4!LenZ)-0.6,10))
not sure y its not working ?? grrrr
but what i am trying to do is simalar to before (didnt get that workin either)
but to make a draw cabinet that has the option of 1 to 4 draws with each draw being able to be given a certain height or be equal to the others
... ie if there are 4 draws and if draw 1 has been given a height of 200mm then the other 3 (if no heights have been specifed) draws with be equal.....so if draw 1 & 2 have been given heights then draws 3 & 4 would be equal
any help would be great thanks...