Simple one in regard to addition.

  • Thread starter Thread starter Lee Grant
  • Start date Start date
L

Lee Grant

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
 
OssieMac said:
=IF(AND(A1>0,B1>0),A1+B1,"")
Click to expand...

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,"")
--
HTH

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

(e-mail address removed)
Replace @mailinator.com with @tiscali.co.uk
 
Back
Top