Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
conditional formula keeps changing
so i have created this sheet to track recruitment calls. in it, i have
created a conditional formula that enters the date and time into a cell when another cell is modified with call notes, ex =IF(D20,NOW(),"") as you can see, it will remain empty until the call notes cell (in the example, D2) is modified. the problem i am having is when i enter data into a different cell, say D5, the date and time in the cell referring to D2 is also changed to the date and time of when i modify D5. i am not sure why this is happening. any help would be much appreciated and if the problem is not clear, please let me know and i will try and clarify. also, i am not sure exactly where i should have posted this. it is my first time posting. thanks |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
conditional formula keeps changing
Yes, NOW() is volatile. See
http://www.mcgimpsey.com/excel/timestamp.html for a couple of solutions In article , nbarr wrote: so i have created this sheet to track recruitment calls. in it, i have created a conditional formula that enters the date and time into a cell when another cell is modified with call notes, ex =IF(D20,NOW(),"") as you can see, it will remain empty until the call notes cell (in the example, D2) is modified. the problem i am having is when i enter data into a different cell, say D5, the date and time in the cell referring to D2 is also changed to the date and time of when i modify D5. i am not sure why this is happening. any help would be much appreciated and if the problem is not clear, please let me know and i will try and clarify. also, i am not sure exactly where i should have posted this. it is my first time posting. thanks |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
conditional formula keeps changing
thanks for the help!
"JE McGimpsey" wrote: Yes, NOW() is volatile. See http://www.mcgimpsey.com/excel/timestamp.html for a couple of solutions In article , nbarr wrote: so i have created this sheet to track recruitment calls. in it, i have created a conditional formula that enters the date and time into a cell when another cell is modified with call notes, ex =IF(D20,NOW(),"") as you can see, it will remain empty until the call notes cell (in the example, D2) is modified. the problem i am having is when i enter data into a different cell, say D5, the date and time in the cell referring to D2 is also changed to the date and time of when i modify D5. i am not sure why this is happening. any help would be much appreciated and if the problem is not clear, please let me know and i will try and clarify. also, i am not sure exactly where i should have posted this. it is my first time posting. thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Conditional formatting for changing data | Excel Discussion (Misc queries) | |||
Conditional Formulas for Changing Cell Color | Excel Worksheet Functions | |||
Dynamically Copying Changing Conditional Formatting | New Users to Excel | |||
Changing text color usinf a formula (NOT Conditional Formatting) | Excel Discussion (Misc queries) | |||
Changing a Formula in Conditional Formatting | Excel Worksheet Functions |