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 ().