formula with date for an 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 display todays date
and time.
 
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...
 
Back
Top