IF maximums

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
=IF(OR(C11="BR",C11="FW",C11="NE",C11="HI"),B3*C13*C9,??)

?? .... whatever False contion is

HTH
 
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...
 
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)
 
Back
Top