What are the volatile functions in Excel?

By /
Discussion Room › Category: Interview Question › What are the volatile functions in Excel?
0 Vote Up Vote Down
Admin Staff asked 5 years ago

A volatile function recalculates the formula again and again (whenever any modification occurs in a worksheet).

Highly volatile: NOW (), RAND (), TODAY ()

Almost volatile; CELL (), INDIRECT (), OFFSET (), INFO ().

Question Tags: ,
Scroll to Top