I'm trying to fool-proof a dashboard that I'm handing off to someone else, and it contains some array formulas. If someone edits one of the array formulas and forgets to hit Ctrl+Shift+Enter, right now all that happens is the formula starts returning results that are incorrect in a subtle way.
What I would like is some sort of IF check I could add to the formula that will allow me to return a clear error if they forget to enter it as an array formula.
Something like:
=IF(IsArrayFormula, NormalFormula, "Ctrl+Shift+Enter Required")
VBA's not an option for me, although I won't down-vote if you want to leave a VBA solution for someone who doesn't have that restriction.