| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Insert a date that does not update if a condition is true
Hey and thanks in advance
I need to insert the current date and time into a cell (that will not update again) IF another cell is not empty: IF(C30,NOW()," ") However, this formula allows the date and time to update each time the workbook functions update. I need the date to be fixed. Thx! -- FirstVette52 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| result if a condition is NOT true? | Excel Worksheet Functions | |||
| Continually check if condition is true in VBA | Excel Discussion (Misc queries) | |||
| TRUE condition??? | Excel Discussion (Misc queries) | |||
| How to get date entered recording first time condition is true? | Excel Discussion (Misc queries) | |||
| How Do I Hide A Row (if a condition is true) using a Macro ? | Excel Worksheet Functions | |||
Threaded Mode
