Indirect

[Brian from Maui]

Would the following be considered "volatile" =INDIRECT("A2") and if so WHY?

 

[Andrew Poulsom]

With calculation set to automatic the formula will reevaluate if either A2 or the cell referred to in A2 changes. So yes it is volatile. Why shouldn't it be?

 

[Aladin Akyurek]

On 2002-10-01 12:43, Brian from Maui wrote:
Would the following be considered "volatile" =INDIRECT("A2") and if so WHY?

INDIRECT is volatile. Why? In this case, a design decision, I guess. Also, it is a function that needs to dereference the ref arg it is feeded to. So the reference must be in its most recent state for derefencing for correct results.

 

[Brian from Maui]

Andrew and Aladin,

Thank-you!