Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
simplify a large formula | New Users to Excel | |||
=large formula | Excel Discussion (Misc queries) | |||
Problem with a large formula | Excel Discussion (Misc queries) | |||
Problem with a large formula | Excel Discussion (Misc queries) | |||
to large if formula | Excel Worksheet Functions |