formula with date answer

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
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.
 
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?
Click to expand...

Maybe it'll meet your need to put the number in A1 and this formula in the
"other cell":
=IF(A1>0, 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.
 
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"),"")
 
Back
Top