if...and

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
 
B

Bob Phillips

=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)
 
K

Kirstie Adam

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
 
P

Pete_UK

Thanks for feeding back, Kirstie.

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

Pete
 
B

Bob Phillips

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)
 
Top