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

formula with date answer
 

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?

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

Maybe it'll meet your need to put the number in A1 and this formula in the
"other cell":
=IF(A10, NOW(), "")
You can format the other cell as "date and time" using
Format Cells Number Date
And choosing a "Type" you like.

The date and time updates when somebody makes a change in the workbook.

formula with date answer
 

with data on E2

=IF(AND(ISNUMBER(E2),E2=0),TEXT(NOW(),"ddd,m/d/yy,h:mm"),"")
or
=IF(AND(not(IStext(E2)),E2=0),TEXT(NOW(),"ddd,m/d/yy,h:mm"),"")

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