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



"Excelenator" wrote:


You can actually nest many more than 7 if statements if you use named
formulas. The first thing you have to do is take your current formula
and copy it from the formula bar. Go to Insert\Name\Define and type in
a formula name (I used IFOne) and then paste in your formula in the
Refers to: box replacing the cell reference and then click OK. Once
that is done, create the formula for all the other IF scenarios that
you have and name them in succession (i.e. IFTwo, IFThree etc.) like
you did above. Then in the cell you want the formulas to appear enter
the following IF statement:

IF(IFOne,IFOne,IF(IFTwo,IFTwo,IF(IFThree,IFThree,0 )))

The example above will allow you to nest 21 if statements!


--
Excelenator


------------------------------------------------------------------------
Excelenator's Profile: http://www.excelforum.com/member.php...o&userid=36768
View this thread: http://www.excelforum.com/showthread...hreadid=565179


--
Barb