How do I tie the computer clock with formula execution?

L

lectrous

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

CLR

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

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

Vaya con Dios,
Chuck, CABGx3
 
Top