Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Automatically Converting Formula in a Cell to its Value at the End of the Day
I want the dynamic values in a cell to show until midnight and then like
Cinderella convert to its value only when the clock strikes 12 midnight i.e. when the date changes to the next day, i.e. I'm using the =TODAY() function for this. I am using an "IF" formula and while the date =TODAY() is "true" the formula provides dynamic values but when the date is not true (a fraction of a second after midnight) I want the cell the show its last value on the previous day. Is this possible in Excel 2000? TIA to all replies. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how prevent formula in cell from deleting when deleting value???? | New Users to Excel | |||
Copy cell format to cell on another worksht and update automatical | Excel Worksheet Functions | |||
Cell shows formula and not the result of the formula. | Excel Worksheet Functions | |||
Cell shows formula and not the result of the formula. | Excel Worksheet Functions | |||
looking for a formula | Excel Worksheet Functions |