if...and

  • Thread starter Thread starter Kirstie Adam
  • Start date Start date
K

Kirstie Adam

All,

How do i say, in a IF formula,

if C8 is greater than 0 and C7 is equal to zero, sum C9-E5 and then add on
C10, or else say "see Kirstie"

I've had a few attempts but they keep seem to be giving me the results back
to front!!!

Kirstie
 
=IF(AND(C8>0,C7=0),SUM(C9:E5,C10),"Kirstie")

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)
 
thanks to all, now working brilliantly. and i only wasted hours and hours
and hours........!!!

Kirstie


Try this:

=IF(AND(C8>0,C7=0),C9-E5+C10,"see Kirstie")

Hope this helps.

Pete
 
Thanks for feeding back, Kirstie.

In future, post your problem here sooner rather than later, and save
even more time! <bg>

Pete
 
So did C9-E5 mean c9 MINUS E5 as most interpreted it, or C5 TO E9 as I did?

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)
 
Back
Top