Just put the first formula in the first column and then use the fill handle todrag it across to the subsequent columns. It will change automatically.