Hi all,
From what I understand, a volatile function causes a cell to recalculate, every time excels recalculates (any cell).
So I try to avoid volatile functions whenever I can, to reduce unnecessary recalculation. But sometimes I can't (or sometimes I'm just lazy) so I thought I could avoid recalculation by encasing volatile parts in IF statements. For example:
=IF(1<2,"Always True",[SomethingVolatile]), where [SomethingVolatile] could be RAND(), NOW(), INDIRECT(), OFFSET, etc
I THOUGHT that in the above example, because the volatile part will never run, then this cell won't recalculate (the volatile parts) every time Excel recalculates. Is that true or false? Or partially true? And if false, is there any way to (with formulas/functions/etc) reduce unnecessary recalculation of a formula that contains a volatile function?
Thanks!
From what I understand, a volatile function causes a cell to recalculate, every time excels recalculates (any cell).
So I try to avoid volatile functions whenever I can, to reduce unnecessary recalculation. But sometimes I can't (or sometimes I'm just lazy) so I thought I could avoid recalculation by encasing volatile parts in IF statements. For example:
=IF(1<2,"Always True",[SomethingVolatile]), where [SomethingVolatile] could be RAND(), NOW(), INDIRECT(), OFFSET, etc
I THOUGHT that in the above example, because the volatile part will never run, then this cell won't recalculate (the volatile parts) every time Excel recalculates. Is that true or false? Or partially true? And if false, is there any way to (with formulas/functions/etc) reduce unnecessary recalculation of a formula that contains a volatile function?
Thanks!