Volatile IF Statements

[jamescooper]

=IF(AND(W6<>"",VALUE(W6)=VALUE(TODAY()+1)),"Due in 24 Hours",1)

Hello,

Why is the above formulas second part of the If statement volatile?

This bit:

VALUE(W6)=VALUE(TODAY()+1))

Many thanks.

 

[Kamolga]

What do you mean by volatile?

[LEFT][COLOR=#333333][FONT=Verdana]VALUE(W6)=VALUE(TODAY()+1))[/FONT][/COLOR][/LEFT]

will always be true or false.

By the way, what is the point of saying "if W6 is not empty and equals tomorrow"? If it equals tomorrow, it is already not empty
And what is the format of W6?

 

[Scott T]

Today is a volatile function. Anytime the sheet updated it checks the system date.

 

[Fluff]

The formula is volatile, because Today() is a volatile function.

 

[Kamolga]

If volatile means unpredictable change, today() is not volatile to me

 

[jamescooper]

Thanks guys, appreciate it.

 

[Fluff]

If volatile means unpredictable change, today() is not volatile to me

Volatile functions are functions that recalculate, whenever Xl recalculates, rather than non-volatile functions that only recalculate when a precedent cell changes

Thanks guys, appreciate it.

You're welcome

 

[Kamolga]

Volatile functions are functions that recalculate, whenever Xl recalculates, rather than non-volatile functions that only recalculate when a precedent cell changes

Thank you, now it makes sense

 

[Fluff]

You're welcome