Guess I can throw away my assumption that numbers are for ATP functions only....... more version dependent ...........<<

Thanks to Harlan's and Roger's clarification, please ignore the above statement. If I have not misunderstood, my original assumption (see below) is correct.

If it is a function from the ATP, it gives a number, otherwise it will display #NAME? <<

functions from the ATP = UDF's
number = runtime generated reference to the UDF i.e. function alias

Epinn

"Epinn" wrote in message ...
Thank you both for taking part in my experiment. You two are wonderful. For some reason, I seem to have an affinity with "anomalies" in Excel. ;) What will I find next?

Guess I can throw away my assumption that numbers are for ATP functions only. They are more version dependent and the "consistency" is amazing. Excel will always remain a mystery to me.

Roger, remember our experiment on "COUNTIF says Null = Blank but Blank < Null?" A few days ago, MATCH told me blank = 0 but blank not equal to blank. I didn't post my findings but I am still hanging on to my worksheet. In case you are interested, I can email it to you.

Epinn

"Roger Govier" wrote in message ...
Only in the interests of consistency<bg

--
Regards

Roger Govier


"Bob Phillips" wrote in message
...
So XL14 will generate numbers again?

--
---
HTH

Bob

(change the xxxx to gmail if mailing direct)


"Roger Govier" wrote in message
...
Hi Epinn
Has anyone tried to key in =iseven or =isodd (i.e. without the cell
ref) in a cell?
Yes strange numbers appear when you do this.

But it changes with each version of Excel. Results below for each
version

XL97 #NAME #NAME
XL2000 2000486408 -1909850105
XL2002 #NAME #NAME
XL2003 -708706296 752156679
XL2007 #NAME #NAME

I hadn't seen your later posting about Workday when starting this, so
I didn't try out all the others but in XL2003
=Workday gives a number and in XL2007 it gives #NAME

--
Regards

Roger Govier


"Epinn" wrote in message
...
=iseven(cell ref) or =isodd(cell ref) works fine. This is neat!

Has anyone tried to key in =iseven or =isodd (i.e. without the cell
ref) in a cell? I didn't get an error but ......

I'll let you find out. No idea what that means.

I use V 2003.

Epinn

"Oldersox" wrote in message
...
someone could provide a simpler solution but for the moment you can
use the
'iseven' function (eg: =iseven(cell ref) This will reply true for an
even
number and false for an odd number. You then just need to count the
responses. Two sumifs will do this for you. (note: you will need to
have
the analysis toolpak add-in installed for the iseven function to work
(toolsadd-ins and then tick all add-ins except euros, you can tick
euros if
you ever intend to work in european currencies))

"Bill.liu" wrote:

Hello,
Is there anybody can help me to count the odd or even in an excel
area?
There is a data area which contains natural number.I need to count
how many
odd or even in this area.