You could check for a count of numbers in the range first:

=if(count(a1:b1)<2,"",a1+b1)

And so forth.

Donald wrote:

Thanks for the info, but here is a stupid question when I put this
formula in the unused data cell, It still shows the formulas, example:
a-1 and b-1 are is where the data will be entered so a1+b1 should be
empty and the formulas start in c1.

a-1 b-1 c-1 d-1 e-1
a1+b1 b1-a1 b1/a1

I want to hide the results of the formulas until data is put into a-1
b-1

--
Donald
------------------------------------------------------------------------
Donald's Profile: http://www.excelforum.com/member.php...o&userid=15171
View this thread: http://www.excelforum.com/showthread...hreadid=493310

--

Dave Peterson