Large Formula Help
 

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

Large Formula Help
 

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) )))
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"Canon" wrote:

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