Yup! An array formula makes it much easier to handle this problem from the blog post: > If you have a set of numbers, and you want to add some constant to them

Yup! An array formula makes it much easier to handle this problem from the blog post: > If you have a set of numbers, and you want to add some constant to them, the way you'd do that is to create a formula that adds the constant to a cell and put that into a different location, usually on the same sheet, and then paste that formula to all the cells in an area with the same size as the original data, and hope that you got the dimensions right.