Simple one in regard to addition.

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Lee Grant - 22 Sep 2007 08:07 GMT

I'm sure this is a simple one:

I have two cells, A1 & B1

A1 = 3
B1 is empty

If, in cell A3 I put =a1+b1 how do I stop cell A3 displaying anything until
both A1 and B1 have a value?

Cheers

Reply to this Message

OssieMac - 22 Sep 2007 08:34 GMT

Hi Lee,

=IF(AND(A1>0,B1>0),A1+B1,"")

Regards,

OssieMac

> I'm sure this is a simple one:
>
[quoted text clipped - 7 lines]
>
> Cheers

Reply to this Message

Lee Grant - 22 Sep 2007 08:47 GMT

Excellent.

Thanks - that has done the trick!

Thank you so much!

> Hi Lee,
>
[quoted text clipped - 16 lines]
>>
>> Cheers

Reply to this Message

Sandy Mann - 22 Sep 2007 11:34 GMT

> =IF(AND(A1>0,B1>0),A1+B1,"")

If the OP will never have negative values then OK but if there is a
possibility of negatives then better to use:

=IF(COUNT(A1:B1)=2,A1+B1,"")

Signature

HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings

sandymann2@mailinator.com
Replace @mailinator.com with @tiscali.co.uk

Reply to this Message