Division By Zero

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

On Mon, 26 Sep 2005 21:18:58 +0100, "Sandy Mann" <sandymann2@mailinator.com>
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?

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
<anonymous@discussions.microsoft.com> wrote:

>Because my Alzheimer's is flaring up today???
>
>On Mon, 26 Sep 2005 21:18:58 +0100, "Sandy Mann" <sandymann2@mailinator.com>
>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?

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
sandymann@mailinator.com
Replace@mailinator with @tiscali.co.uk


"Myrna Larson" <anonymous@discussions.microsoft.com> wrote in message
news:ljmhj1l21jkc3v93cc8ch1cmvvoi2gd7kq@4ax.com...
> 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
> <anonymous@discussions.microsoft.com> wrote:
>
>>Because my Alzheimer's is flaring up today???
>>
>>On Mon, 26 Sep 2005 21:18:58 +0100, "Sandy Mann"
>><sandymann2@mailinator.com>
>>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?