How do I tie the computer clock with formula execution?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

lectrous - 21 Mar 2006 03:46 GMT

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.

Reply to this Message

Peo Sjoblom - 21 Mar 2006 04:39 GMT

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

Signature

Regards,

Peo Sjoblom

Northwest Excel Solutions

www.nwexcelsolutions.com

(remove ^^ from email address)

Portland, Oregon

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

Reply to this Message

CLR - 21 Mar 2006 14:23 GMT

Maybe something like this will help.....
Where E1 contains =NOW()

=IF(AND(A1="",E1>38797.34301),"No Run","")

Vaya con Dios,
Chuck, CABGx3

Reply to this Message