Re: [office-comment] [formula] Equality operator

[Eike Rathke <erack@sun.com>]

Hi Brad,

On Saturday, 2007-03-31 12:04:55 +1000, Brad Hards wrote:

> > Ah, so yes, I was mislead, =ISNA(NA()=NA()) must be TRUE because
> > =NA()=NA() is Error, that's what the comment refers to. So what in that
> > test case's comment do you actually disagree with?
> I want to be able to compare errors. NA() = NA() should be true, not an error.

Well, yes, but that's just not what spreadsheet implementations do. The
error is propagated through all expressions unless some ISNA or ISERROR
or such is involved.

  Eike