Japanese version. Array formulas are less well known, but are a powerful feature available in Excel 2007 or later. When used properly, array formulas can simplify a sheet by omitting intermediate calculation cells and formulas.Although powerful, it also has many disadvantages, so you need to consider the trade-offs when adopting it. In Excel 2019 and later, a more convenient feature called Spill has been added that eliminates many of the disadvantages. This is recommended over array formulas, and Microsoft has a policy of moving to it. Use Cases and Benefits. Common formulas in a single cell formula. For example, if a table has a quantity and a price, and you … Continue reading Array formula.(Microsoft Excel)