Feb 19 2020 02:46 PM
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 Statements so I started using IFS, because it is way neater.
Was running INQUIRE to see whether I got any errors and noticed something peculiar: Every formula with an IFS is classed as an ARRAY formula (even though I don't even use Ctrl+Shift+Enter anywhere...
Is that deliberate/true?
Thanks,
David
Feb 20 2020 05:35 AM
Feb 20 2020 10:11 AM - edited Feb 20 2020 10:13 AM
@Jan Karel Pieterse - Here is one :)
Feb 21 2020 04:40 AM