Forum Discussion

Copper Contributor

Feb 19, 2020

Inquire classes any IFS as an Array formula? :confused:

Hello, I have recently updated my vocabulatory of functions and I absolutely adore the new FILTER and XLOOKUP. As I was beautifying some formulas, I noticed that I have tons and tons of nested IF St...

excel

Formulas and Functions

JKPieterse

Silver Contributor

Feb 20, 2020

Can you show us one such flagged formula please?

DavidEberhardt
Copper Contributor
Feb 20, 2020
JKPieterse - Here is one 🙂
Test IFS.xlsx9 KB
Test IFS - Workbook Analysis.xlsx31 KB
- JKPieterse
  Silver Contributor
  Feb 21, 2020
  This is because DA Excel stores any formula which is array-capable as an "array formula", for backward compatibility reasons. If I open your workbook in Excel 2010, the IFS formula is an array formula.