Topic: EXCEL GURUS! Please Help ...  (Read 791 times)

0 Members and 1 Guest are viewing this topic.

Marcos

  • Cafe VIP
  • Posts: 467
EXCEL GURUS! Please Help ...
« on: October 16, 2007, 10:59 PM »
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

  • Super Admin
  • Posts: 15093
  • Founder & Owner of DrummerCafe.com
    • bartelliott
    • bartelliott
    • w w w . B a r t E l l i o t t . c o m
Re: EXCEL GURUS! Please Help ...
« Reply #1 on: October 17, 2007, 12:03 AM »
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

  • Cafe VIP
  • Posts: 467
Re: EXCEL GURUS! Please Help ...
« Reply #2 on: October 17, 2007, 12:27 AM »
Touchdown!  :D

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

diddle

  • Guest
Re: EXCEL GURUS! Please Help ...
« Reply #3 on: October 17, 2007, 08:54 AM »
Good job, Bart (and Mrs. Bart) ... now I know who to ask for Excel help!  :D

 

Drummer Cafe on Twitter Drummer Cafe on Facebook Drummer Cafe on YouTube Drummer Cafe on Pinterest Drummer Cafe on Instagram