EXCEL GURUS! Please Help ...

[Marcos]

I have the following formula and it works correctly for both CC and EX. It contains the correct currency value. However, the word "FALSE" is parked right next to the value (e.g. "$10.75FALSE") and it would be nice if the word was not there. Anyone?

=IF(Q10="CC",SUM(H10:M10)-1.9%)&IF(Q10="EX",SUM(H10:M10)-3%)

[Bart Elliott]

Okay ... my wife and I sat down and had a look at this together.

First of all ... you wouldn't use &IF, you would need to use AND. But doing this doesn't make since. If Q10 will have either the value "CC" or "EX", then you could just do this:

=IF(Q10="CC",SUM(H10:M10)-1.9%,SUM(H10:M10)-3%)

This checks to see if "CC" is in the cell. If it's not, then it doesn't matter if it's "EX" or not, so the above formula would calculate the -3%.

Now, if there is other possible values in Q10 other than "CC" or "EX", but you only want to calculate the formula if there is a "CC" or "EX" in the Q10 cell, you could use this formula:

=IF(Q10="CC",SUM(H10:M10)-1.9%,IF(Q10="EX",SUM(H10:M10)-3%,0))

You can use whatever value you want if Q10 is not "CC" or "EX". The above formula just used 0 to display if no other value is possible. You can have it enter whatever value or text that you want.

[Marcos]

Touchdown!  :D

That did the trick, Thank you Bart and please thank your wife for me.

[diddle]

Good job, Bart (and Mrs. Bart) ... now I know who to ask for Excel help!  :D