if...and

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Kirstie Adam - 31 Mar 2008 14:18 GMT

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

Reply to this Message

Bob Phillips - 31 Mar 2008 14:28 GMT

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

Signature

HTH

Bob

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

> All,
>
[quoted text clipped - 7 lines]
>
> Kirstie

Reply to this Message

MartinW - 31 Mar 2008 14:29 GMT

Hi Kirstie,

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

HTH
Martin

> All,
>
[quoted text clipped - 7 lines]
>
> Kirstie

Reply to this Message

Pete_UK - 31 Mar 2008 14:29 GMT

Try this:

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

Hope this helps.

Pete

On Mar 31, 2:18 pm, "Kirstie Adam" <kirst...@ecosse.net(nospam)>
wrote:

> All,
>
[quoted text clipped - 7 lines]
>
> Kirstie

Reply to this Message

Kirstie Adam - 31 Mar 2008 15:37 GMT

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

On Mar 31, 2:18 pm, "Kirstie Adam" <kirst...@ecosse.net(nospam)>
wrote:

> All,
>
[quoted text clipped - 8 lines]
>
> Kirstie

Reply to this Message

Pete_UK - 31 Mar 2008 16:08 GMT

Thanks for feeding back, Kirstie.

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

Pete

On Mar 31, 3:37 pm, "Kirstie Adam" <kirst...@ecosse.net(nospam)>
wrote:

> thanks to all, now working brilliantly. and i only wasted hours and hours
> and hours........!!!
[quoted text clipped - 26 lines]
>
> - Show quoted text -

Reply to this Message

Bob Phillips - 31 Mar 2008 16:27 GMT

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

Signature

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........!!!
[quoted text clipped - 24 lines]
>>
>> Kirstie

Reply to this Message