< Back to screenshot

Array formulas

Excel array formulas are used extensively in PopTools to return multiple results with a single formula. The result of each array formula will fill more than one cell. PopTools includes menu options to enter many of the array formulas, but others must be entered manually. To enter an array formula you need to know the size of the result. Array formulas can be created in the same way that you create other formulas, except you must press CTRL+SHIFT+ENTER to enter the formula. The image below demonstrates this process, using Excel's built-in formula for matrix multiplication.