| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
NOW() function help...
I'm currently running a spread sheet that will capture the time when a
condition is met in another cell... The problem is, whenever the cell is changed from one condition to another, the time does not reflect the latest change; the time is still constant from the first entry. Is it possible to get the time to refresh everytime the cell value is changed without having to delete the first entry? formula I'm using... =IF((+K9+O9+S9+W9+AA94),"Not Eligible",IF(ISBLANK(AC9),"",IF(OR(AC9="A",AC9="D" ,AC9="NA",AC9="MSG",AC9="NIS"),IF(AD9="",NOW(),AD9 ),""))) |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| copy of excel file not showing formulal/function in the function b | Excel Discussion (Misc queries) | |||
| LINKEDRANGE function - a complement to the PULL function (for getting values from a closed workbook) | Excel Worksheet Functions | |||
| Offset function with nested match function not finding host ss. | Excel Worksheet Functions | |||
| Emulate Index/Match combo function w/ VBA custom function | Excel Worksheet Functions | |||
| Nested IF Function, Date Comparing, and NetworkDays Function | Excel Worksheet Functions | |||
Threaded Mode
