Forum Discussion
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...
JKPieterse - Here is one 🙂
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.