When executing a formula, only the result for one of the cells is calculated. Why?

Make sure Insert Mode (not Overwrite Mode) is selected in the Data menu.