What are the volatile functions in Excel?

Discussion RoomCategory: Interview QuestionWhat are the volatile functions in Excel?
Admin Staff asked 4 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 ().

Scroll to Top