| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Keeping date from changing
I'm having a problem trying to get this formula to work
=IF(C4=0,NOW(),IF(C40,"",IF(E4="",NOW(),E4))). The date keeps changing each day. Is formula works fine =IF(B3="","",IF(C3="",NOW(),C3)). Tools/options/calculations/Iterations. Can anyone please help me with the first formula. Thanks in advance! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I drag a formula keeping cells the same but changing sheets | Excel Worksheet Functions | |||
| Keeping the format of a date | Excel Worksheet Functions | |||
| Keeping a date when today's date changes | New Users to Excel | |||
| How do I fill down keeping one cell calculation from changing in . | Excel Discussion (Misc queries) | |||
| Keeping a transfered value the same after changing the original va | Excel Worksheet Functions | |||
Threaded Mode
