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

Your Answer