With calculation set to automatic, this function will always calculate: =IF(a=b,a,NOW())
a) When F9 is pressed
b) When SHIFT + F9 is pressed
c) Never as it has no dependents
d) When a column is inserted
e) When a name is defined on the worksheet