OK so on my expense report, I can put whether I paid for an Item or if I used the company Credit Card

Is there a way that I can write a function that subtracts what is on the company card from what I paid for in the total?

=SUM(M11:M25)- IF(C=AMEX) is the idea

can this be done?

9/18/2006 6:01:43 PM

look up the SUMIF function

[Edited on September 18, 2006 at 6:13 PM. Reason : SUMIF(C11:C25,"<>AMEX",M11:M25)]

9/18/2006 6:09:14 PM

yeah

excel has a nice function help feature if you click the fx next to the formula bar

[Edited on September 18, 2006 at 6:10 PM. Reason : .]

9/18/2006 6:09:43 PM

IT LOOKS LIKE U ARE POSTING A THREAD IN TECH TALK!

WOULD U LIKE 2 SEARCH GOOGLE?

9/18/2006 6:24:11 PM

ok i can fix this

9/18/2006 6:26:21 PM

ok qntmfred's equation didnt quite do it, but it got Help to figure out what i was up to

thanks

9/18/2006 7:28:52 PM

if my boss hadnt have blocked all my internet at work i coulda answered this

9/18/2006 7:32:57 PM