IF maximums

B

B G

this is reposted.

I am not having much luck with that - I'm wondering if it would be easier to
do something like this

4 of the Cells in column B are = to $34, could I do a formula that basically
says:

If cell C11=BR or FW or NE or HI, then multiply cell B3*C13*C9.

This would elimiate the need for more than 7 IF statements, as 4 of the 10
would be included in the statement above.

I'm getting there, slowly - thanks for your help.
 
T

Toppers

=IF(OR(C11="BR",C11="FW",C11="NE",C11="HI"),B3*C13*C9,??)

?? .... whatever False contion is

HTH
 
B

B G

OK - so if I put in just the formula you wrote - that works, but now what if
I want to include the other cell value possibilities; i.e., BL=30.50;
EP=32.50; ER=38.75 ; these amounts will vary which is why I had the amounts
in before as a cell (BL=B3 which equalled 30.50.

=IF(OR(C11="BR",C11="FW",C11="HI",C11="NE"),34*C13*C9),IF(C11="BL",B3*C13*C9,IF(C11="EP",B5*C13*C9))

This is what I put in - but it brings back #VALUE!
--
Barb


Excelenator said:
Use this formula


Code:
--------------------
IF(OR(C11="BR",C11="FW,C11="NE,C11="HI"),B3*C13*C9, [condition if false here most likely the other if statements])
--------------------


B said:
this is reposted.

I am not having much luck with that - I'm wondering if it would be
easier to
do something like this

4 of the Cells in column B are = to $34, could I do a formula that
basically
says:

If cell C11=BR or FW or NE or HI, then multiply cell B3*C13*C9.

This would elimiate the need for more than 7 IF statements, as 4 of the
10
would be included in the statement above.

I'm getting there, slowly - thanks for your help.
Click to expand...
Click to expand...
 
E

Excelenator

The problem is the ")" after C9 in your formula. It should be remove
and an additional ")" should be placed at the end of the formula.

=IF(OR(C11="BR",C11="FW",C11="HI",C11="NE"),34*C13*C9*)*,IF(C11="BL",B3*C13*C9,IF(C11="EP",B5*C13*C9)
 
Top