| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Simple problem, simple formula, no FUNCTION !
I need to automatically date stamp a two column entry and retain the date.
The formula in column C could be =IF(AND(A10,B1=0),TODAY(),NOCHANGE) This would result in the date appearing in column C when an entry is made in A1 and the date holding when an entry is made in B1 - how simple. Except there isn't a function like NOCHANGE available. (this would also be the perfect solution for killing circular references and reiterations in a single cell) So, can anbody please advise how I can achieve the same result from a formula using the available functions in Excel? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| simple formula problem | Excel Discussion (Misc queries) | |||
| Simple function problem | Excel Worksheet Functions | |||
| Simple Simple Excel usage question | Excel Discussion (Misc queries) | |||
| Function formula for simple worksheet | New Users to Excel | |||
| Make it more simple or intuitive to do simple things | Charts and Charting in Excel | |||
Threaded Mode
