A formula can only return a result the cell in which it is contained.
Therefore, it cannot update "another cell" as you are looking for. The
formula

=IF(A1=0,NOW(),"Not Zero")

will return the current date and time (be sure to format the cell for date
and time) if A1 is 0. If A1 is not zero, it will return the text "Not Zero".
Substitute the value you want to return if A1 is not zero.

This will not, and cannot, change any other cell.


"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 give todays date
and
time?