If Statements

[kcdill]

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()))

 

[polly]

Well as to the second Question...you can only nest 7 IF() in a formula. You may try adding OR(), AND() to the IF() statements.
As to the first Question I think if you post some more info , like what the Data looks like, the formula could probably be shortened and changed.

PAul

 

[Zack Barresse]

i'm sure there's a formula solution to your quandry here. just post a little more info on what's in D106, G106 & H106; what are your requirements, and the desired outcome. maybe w/ HTML maker.