formula with date answer

J

joe

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?
 
C

Chip Pearson

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.
 
M

MyVeryOwnSelf

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.
 
S

swordsman

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"),"")
 
Top