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

[Eike Rathke <erack@sun.com>]

Hi David,

On Wednesday, 2007-06-13 11:12:42 -0400, David A. Wheeler wrote:

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

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. Or
I misunderstood that completely..

  Eike

-- 
Automatic string conversions considered dangerous. They are the GOTO statements
of spreadsheets.  --Robert Weir on the OpenDocument formula subcommittee's list.