The problem is that using the computer clock is volatile, the NOW function
will always update unless you use a macro or under some circumstances
circular references
http://www.mcgimpsey.com/excel/timestamp.html
--
Regards,
Peo Sjoblom
Northwest Excel Solutions
www.nwexcelsolutions.com
(remove ^^ from email address)
Portland, Oregon
"lectrous" wrote in message
...
I am trying to have excel execute an "IF" formula based on the computer
clock. For example, if there is no entry in a cell on a given day the a
certain result should be displayed (such as $0.00 or "No Run"). I cant
seem
to find help on this function. Thanks.