NOW() is a volatile Excel function because its value changes whenever the worksheet recalculates, even if no inputs change. Volatile functions automatically recalculate every time any cell is modified. SUM, THEN (not a real function), and AVERAGE are non-volatile.