| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Today() & Now() function
Why does Today() & Now() function show "Volatile" when I click in the formula
then click the "fx" in my worksheet? Is it messing with my other formulas that use the Today() & Now() function? Luke |
|
#2
|
|||
|
|||
|
Today() & Now() function
Volatile mean that the function is calculated every time Excel
performs any calculation. -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "Luke" wrote in message ... Why does Today() & Now() function show "Volatile" when I click in the formula then click the "fx" in my worksheet? Is it messing with my other formulas that use the Today() & Now() function? Luke |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Today() & Now() function
Hi Guys, sorry to butt in on this old issue - but How can we make TODAY()
non-volatile????? FBC Dave "Chip Pearson" wrote: Volatile mean that the function is calculated every time Excel performs any calculation. -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "Luke" wrote in message ... Why does Today() & Now() function show "Volatile" when I click in the formula then click the "fx" in my worksheet? Is it messing with my other formulas that use the Today() & Now() function? Luke |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I use the TODAY function with the SUMIF function? | Excel Worksheet Functions | |||
| creating function (vba) with range arguments | Excel Worksheet Functions | |||
| Automatically up date time in a cell | Excel Discussion (Misc queries) | |||
| clock | Excel Worksheet Functions | |||
| Today() or Date() function help | Excel Discussion (Misc queries) | |||
Linear Mode
