Re: Switch off @array

Ronald de Vos wrote:
> Every function I use starts with @array, even when I don't want to use
> @array.
> I would like to know how to switch this off.

There's no such switch.  Certain functions are array functions by design.  For 
some of them it makes sense (@TREND, @GROWTH), while for others it doesn't 
(@ISBLANK, @DATEINFO).  The prefix as such doesn't cause any problems, unless 
you're trying to build a summary formula which uses an array algorithm to 
compute a single result; in such cases, you have to remove the prefix manually 
after wrapping the array function inside a summary function.  Under some 
conditions, the prefix then repositions itself to the front of the formula, 
similar to how QP does it for strictly defined array functions.

Cheers,
Uli

Every function I use starts with @array, even when I don't want to use
@array.
I would like to know how to switch this off.