Hi Eugene,

From what you've described, I think your formula could be simplified down
to:
=(IF(D443="F",Test_Full_Price,IF(D443="CC",Test_Cl ub_Price,0))+Test_Cupon)*T
est_Bought

Cheers
PS: Coupon?

--
macropod
[MVP - Microsoft Word]


"EuGene C. White" wrote in message
...
Biff,

Thank you. That helped. I guess the answer to your question is no. It
is
two different parts.

In cell J443, I have the followng formula, which works fine. What I am
trying to do is expand the functionality to include cupons and/or sales.


=IF((D443)="CC",SUM((Test_Full_Price)*0.855),IF((D 443)="F",SUM((Test_Full_Pr
ice)*0.855),IF((D443)="N",0)*IF((D443)="",0)))

This formula checks for CC (for club card), F (for full price), N (for
non-club card items) and a blank cell. I am trying to build on that
formula
to also include cupons and/or sales. Your original post was a start. I
will
work with that one and go on.

Again,

Thank you very much,

Gene

--
/s/ Gene


"Biff" wrote:

As written, there is no value_if_false argument so it defaults to FALSE.

You have it written so that the second IF is an argument to the first
SUM
function. Is that really what you want?

Maybe this:


=IF(D443="F",SUM((Test_Full_Price)*(Test_Bought)+( Test_Bought)*(Test_Cupon))
,IF(D443="CC",SUM((Test_Club_Price)*(Test_Bought)+ (Test_Bought)*(Test_Cupon)
),"not
defined"))

Biff

"EuGene C. White" wrote in
message
...
I can't get the following formula to work beyond the first part. After
that
it returns "FALSE". What am I doing wrong?

=IF((D443)="F",SUM((Test_Full_Price)*(Test_Bought) +((Test_Bought)*(Test_Cupo
n)),IF((D443)="CC",SUM((Test_Club_Price)*(Test_Bou ght)+((Test_Bought)*(Test_
Cupon))))))
--
/s/ Gene