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_Cupo n)),"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_Cupon)),IF((D443)="CC",SUM(( Test_Club_Price)*(Test_Bought)+((Test_Bought)*(Tes t_Cupon))))))
--
/s/ Gene