Re: [office-formula] Considering IFERROR function: Add IFNA andIFERROR

["David A. Wheeler" <dwheeler@dwheeler.com>]

I said:
> > Since MOOX has the default value as "", I intend to do the same for
> > IFERROR, and for consistency do that with IFNA as well.

Eike Rathke:
> Hu? The function doesn't have a "default value" (what's that anyway?).
> The description of the second parameter, value-if-error, reads
> | The value to return if value evaluates to an error. If value-if-error
> | is an empty cell, it is treated as an empty string.
> So, in the error case, if the second parameter is given as a reference
> to an empty cell the function returns an "" empty string.

You're absolutely right!  Hm.  Safest to have no default then.

--- David A. Wheeler