Large Formula Help

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
 
L

Luke M

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to keep formula and be able to input value in cell? 0
@Need help with a formula 8
IF FORMULA 14
Filter with an IF, AND, NOT formula 1
I am stumped. Help with Formula... 5
Copying Value from the Wrong Cell 4
IF Formula 8
formula help 4

Top