OASIS Mailing List ArchivesView the OASIS mailing list archive below
or browse/search using MarkMail.


Help: OASIS Mailing Lists Help | MarkMail Help

office-formula message

[Date Prev] | [Thread Prev] | [Thread Next] | [Date Next] -- [Date Index] | [Thread Index] | [List Home]

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

David A. Wheeler wrote:
> > Actually, how about IFERROR and a new function, IFNA?

Eike Rathke:
> I like the idea behind IFNA additionally to IFERROR to distinguish this
> case.

Excellent!  Unless there's a complaint ASAP, I will add drafts for these two functions (IFERROR and IFNA).  Since MOOX has the default value as "", I intend to do the same for IFERROR, and for consistency do that with IFNA as well.

> In the current state of the spec only LOOKUP, VLOOKUP and HLOOKUP
> are defined to return NA() though if the lookup value isn't found.
>[and FIND and SEARCH...]

> What other functions would we need to define to return NA() on some
> condition?

Well, there's always NA()   :-).  Seriously, I think that's enough.  We have a number of search functions that return NA(), and now we can easily change what NA does using IFNA().  Similarly with general errors.

> I think IFEQ would be only confusing..

Okay.  I think the utility of IFEQ goes _way_ down once IFNA() and IFERROR() are included, so let's drop IFEQ().

--- David A. Wheeler

[Date Prev] | [Thread Prev] | [Thread Next] | [Date Next] -- [Date Index] | [Thread Index] | [List Home]