To address these issues and enhance the formula writing experience, Microsoft has developed a new tool called the Advanced Formula Environment (AF) for Excel 2019 and later versions.

Advanced formula environment, a Microsoft Garage project, enables Excel users to write complex formulas efficiently and then share them in an Office Add-In for Excel.

Excel Is Much More Than a Spreadsheet. Advance Your Skills With This $39 Course. Master the art of Excel in just eight courses.

Most formulas in Excel return a single-cell result. However, if an Excel formula returns a set of values, the result will spill over to neighboring cells. Spilling and dynamic array formulas are ...