Just enter in the first cell as array. And drag down. Do not enter the formulae in one go for all the cells.