Large Formula Help

  • Thread starter Thread starter Canon
  • Start date Start date
C

Canon

Office 2007
I am using the following formula;
=IF($E$5="5MM",D6*8.5,IF($E$5="6MM",D6*8.65))
I need to add the following exceptions;
If cell C5 = 3200 or 3200F/T then use the above formula, but change D6*8.5
to D6*6.70
If cell C5 = 850 then use the above formula with no changes
 
Note that the way you presented your question, there is no alternative if C5
doesn't equal any of those choices. Thus, if C5 is not one of those choices,
formula returns "FALSE"

=IF(C5=850,IF($E$5="5MM",D6*8.5,IF($E$5="6MM",D6*8.65)),IF(OR(C5=3200,C5="3200F/T"),IF($E$5="5MM",D6*6.7,IF($E$5="6MM",D6*8.65))))
 
Back
Top