I'm not sure what you mean by "the opposite". The formula I gave in my
earlier response tests to see if A1 has a value....

Dave
--
Brevity is the soul of wit.


" wrote:

Dave Thanks, One more thing Now I need the opposite if A1 has a value How do
I write the logic for that.

"Dave F" wrote:

Here's an example: =IF(A1=2,B1,C1)

Dave
--
Brevity is the soul of wit.


" wrote:

How can I have a formula include data when applicable and at the same time
when that cell does not apply to have it default to another cell to calculate
a sum ?