Before using this function be sure to read and understand how it works. It
was a revelation to me that ISEVEN(2.5) will return TRUE because it looks
only to the left of the decimal point. In Harald's formula you can adjust
the discrimination by using different values in place of .001.

I also looked at the EVEN function and discovered that it rounds UP to the
nearest even number. Then the examples show that EVEN(-1) is rounded "up"
to -2. I thought that -2 was less than -1. At least it was when I went to
school, but that was a long time ago, maybe it has changed since then. :)

-- Carlos

"SimonW" wrote in message
...
Hi
I can not get the ISEVEN function to work on a particular machine with XP
Home Edition and Works 10. I've installed Excell 2000 SP3 on the machine
but
the ISEVEN function returns #NAME. Visual Basic, Tools, References looks
OK
with the 9.0 Object Library.

It works fine on my production machine XP Pro Office 2000 SP3.

Consequently, I can't get my spreadsheet to work on the destination
machine.
Any ideas anyone? Please help!. TIA, Simon