Question 1. How can I make this thing shorter?
=IF((G106*H106)>900,"Special",IF(VesselID,SETV(IF(D106=20,VLOOKUP((G106*H106),CoverRingFlangeThickness,2,TRUE),IF(D106=24,VLOOKUP((G106*H106),CoverRingFlangeThickness,4,TRUE),IF(D106=30,VLOOKUP((G106*H106),CoverRingFlangeThickness,6,TRUE),IF(D106=36,VLOOKUP((G106*H106),CoverRingFlangeThickness,8,TRUE),"Size?")))))+Summary!$D$9,GETV()))
Question 2. Can I add another If Statement for an 18” flange? such as IF(D106=18,VLOOKUP((G106*H106),CoverRingFlangeThickness,2,TRUE). I tried the formula below and get error messages. Do I have too many Ifs?
=IF((G106*H106)>900,"Special",IF(VesselID,SETV(IF(D106=18,VLOOKUP((G106*H106),CoverRingFlangeThickness,2,TRUE),IF(D106=20,VLOOKUP((G106*H106),CoverRingFlangeThickness,4,TRUE),IF(D106=24,VLOOKUP((G106*H106),CoverRingFlangeThickness,6,TRUE),IF(D106=30,VLOOKUP((G106*H106),CoverRingFlangeThickness,8,TRUE),IF(D106=36,VLOOKUP((G106*H106),CoverRingFlangeThickness,10,TRUE),"Size?"))))))+Summary!$D$9,GETV()))
=IF((G106*H106)>900,"Special",IF(VesselID,SETV(IF(D106=20,VLOOKUP((G106*H106),CoverRingFlangeThickness,2,TRUE),IF(D106=24,VLOOKUP((G106*H106),CoverRingFlangeThickness,4,TRUE),IF(D106=30,VLOOKUP((G106*H106),CoverRingFlangeThickness,6,TRUE),IF(D106=36,VLOOKUP((G106*H106),CoverRingFlangeThickness,8,TRUE),"Size?")))))+Summary!$D$9,GETV()))
Question 2. Can I add another If Statement for an 18” flange? such as IF(D106=18,VLOOKUP((G106*H106),CoverRingFlangeThickness,2,TRUE). I tried the formula below and get error messages. Do I have too many Ifs?
=IF((G106*H106)>900,"Special",IF(VesselID,SETV(IF(D106=18,VLOOKUP((G106*H106),CoverRingFlangeThickness,2,TRUE),IF(D106=20,VLOOKUP((G106*H106),CoverRingFlangeThickness,4,TRUE),IF(D106=24,VLOOKUP((G106*H106),CoverRingFlangeThickness,6,TRUE),IF(D106=30,VLOOKUP((G106*H106),CoverRingFlangeThickness,8,TRUE),IF(D106=36,VLOOKUP((G106*H106),CoverRingFlangeThickness,10,TRUE),"Size?"))))))+Summary!$D$9,GETV()))