Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I tie the computer clock with formula execution?
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. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I tie the computer clock with formula execution?
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. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I tie the computer clock with formula execution?
Maybe something like this will help.....
Where E1 contains =NOW() =IF(AND(A1="",E138797.34301),"No Run","") Vaya con Dios, Chuck, CABGx3 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Is it possible? | Excel Worksheet Functions | |||
Match then lookup | Excel Worksheet Functions | |||
adding row to forumla | Excel Discussion (Misc queries) | |||
Creating a check mark box | Setting up and Configuration of Excel | |||
Match / Vlookup within an Array formula | Excel Discussion (Misc queries) |