Sum Functions - cell prompting

[Jason S]

I have a simple sum formula of 2 cells I have but I want
to make sure that the person puts a number in both cells.
I.E. the formula won't work and will notify the person
they must enter in values for both cells. So I guess I
need a "calculate" button and it looks at both cells.

HELP!!!

 

[JE McGimpsey]

How about:

=IF(COUNT(A1:B1)<2,"Enter Data in BOTH A1 and B1",A1+B1)

 

[Jason]

Worked Great, THANKS!

-----Original Message-----
How about:

=IF(COUNT(A1:B1)<2,"Enter Data in BOTH A1 and B1",A1+B1)


.