formula with date for an answer
 

Can someone give me an example of a formula that will look at the contents of
one cell, and if that cell is = 0 then another cell will display todays date
and time.

formula with date for an answer
 

another way
=IF(AND(NOT(ISTEXT(E2)),E2=0),NOW(),"?")

"joe" wrote:

Can someone give me an example of a formula that will look at the contents of
one cell, and if that cell is = 0 then another cell will display todays date
and time.

formula with date for an answer
 

Joe,

The formula can't put anything into another cell, but you could have a formula in the cell
that's to show the date if another cell is = 0.

If A2 is the cell to be examined for =0, put this in the cell that's to display the date.

=IF(A2=0,NOW(),"")

This will display the current date-- it doesn't freeze the date. Today it will display
today's date. Tomorrow, tomorrow's date.
--
Earl Kiosterud
www.smokeylake.com

Note: Top-posting has been the norm here.
Some folks prefer bottom-posting.
But if you bottom-post to a reply that's
already top-posted, the thread gets messy.
When in Rome...
-----------------------------------------------------------------------
"joe" wrote in message
...
Can someone give me an example of a formula that will look at the contents of
one cell, and if that cell is = 0 then another cell will display todays date
and time.