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 and IFERROR

Hi David,

On Sunday, 2007-06-10 20:23:25 -0400, David A. Wheeler wrote:

> Actually, how about IFERROR and a new function, IFNA?
> Semantics of IFNA(expr, NAvalue) is
> IF(ISNA(expr);expr;NAvalue) except expr is evaluated only once.

I like the idea behind IFNA additionally to IFERROR to distinguish this
case. 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. What
other functions would we need to define to return NA() on some
condition? What does ECMA/MOOXML do (besides that it doesn't define

David already mentioned FIND, SEARCH comes to my mind.

> Note that given IFERROR and IFNA, I think IFEQ is less-needed, and we
> certainly don't need an IFEQ that has the weird special casing
> I suggested earlier.

I think IFEQ would be only confusing..


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

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