The doctor said to the patient, "I've got two pieces of bad news for you -
you've got cancer and Alzhimer's"
"Oh well," said the patient, "At least I haven't got cancer!" <g

--
Regards


Sandy

Replace@mailinator with @tiscali.co.uk


"Myrna Larson" wrote in message
...
Somehow I must have been thinking about ISNUMBER(B5), even though I was
reading help on the N() function. As I said, must be a "bad Alzheimer
day".

On Mon, 26 Sep 2005 21:24:22 -0500, Myrna Larson
wrote:

Because my Alzheimer's is flaring up today???

On Mon, 26 Sep 2005 21:18:58 +0100, "Sandy Mann"

wrote:

Myrna,

I'm not, (can't), trying to answer for Aladin, but I don't understand
what
you mean by:

According to the documentation for the N function, it shouldn't work

My Help says for N:

*************************
If value is or refers to N returns
A number That number
************************

If N returns a 0 then it is the same as:

=IF(0,"Alex","Sandy")

which will return "Sandy"

Why do you find it counter-intuitive?