function "ISEVEN" when zero.

L

Leo Rod

I'm modeling a french roulette in excel and when defining the events the
function "iseven" when the value is zero returns "true".
On a strict sense 0/N=0 and 0+2=Even but for roulette purposes, zero (or
double zero) is neither even or odd.

Is there an specific reason why Excel have zero as even or to define this
function to be "#Value" or "#N/A"??

Does anybody know how can I get around this situation?

Please let me know

Leo.
 
H

Harlan Grove

Leo Rod said:
. . . but for roulette purposes, zero (or double zero) is neither even or
odd.
Click to expand...

That's nice. That's just one game of chance, a game not many gamblers bother
playing. Perhaps this is what most people would consider exceptional
circumstances which no general software should ever bother to emulate?!
Is there an specific reason why Excel have zero as even or to define this
function to be "#Value" or "#N/A"??
Click to expand...

Excel tries (often fails, but tries nevertheless) to follow the rules of a
subject that seems to be unfamilar to you - mathematics. In the mathematics
of integers and every every algebraic field generalized from them, 0 is an
even number for the extremely simple reason that 0 / 2 = 0, a whole number.
That's how most people would expect it to operate. Fortunately, Excel caters
to the majority of people who care a bit about mathematics and not at all
about the rules of roulette.
Does anybody know how can I get around this situation?
Click to expand...

The only way you could distinguish between 0 and 00 in Excel is if both or
at least 00 were text, and I'll assume it's just "00". The following formula
should handle all cases.

Check if 'Even' in roulette terms: =AND(value>0,ISEVEN(value))
 
P

Pete_UK

Sandy,

typo:

=IF(B25=0,"Neither Odd Nor Even",ISEVEN(B25))

Don't understand your first sentence !!

Pete
 
D

Dave Peterson

Excel returns true when you use =iseven(0) because 0 is an even number. It's a
whole number that has a remainder of 0 when divided by 2.

Maybe you could check first:
=if(a1=0,"neither",iseven(a1))

But I'm not sure how you distinguish between 0 and 00.

If you treat the entries as text (or numbers), maybe:
=if(or(a1={0,"0","00"}),"neither",iseven(a1))
 
S

Sandy Mann

Pete_UK said:
Don't understand your first sentence !!
Click to expand...

Neither do I. M head knew what I was trying to say it was just my fingers
that were confused! <g>

--

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings

[email protected]
Replace @mailinator.com with @tiscali.co.uk
 
L

Leo Rod

Thank you.

Dave Peterson said:
Excel returns true when you use =iseven(0) because 0 is an even number.
It's a
whole number that has a remainder of 0 when divided by 2.

Maybe you could check first:
=if(a1=0,"neither",iseven(a1))

But I'm not sure how you distinguish between 0 and 00.

If you treat the entries as text (or numbers), maybe:
=if(or(a1={0,"0","00"}),"neither",iseven(a1))
Click to expand...
 
L

Leo Rod

"That's just one game of chance, a game not many gamblers bother playing"

Have you been in Vegas recently?
I was there last month and you'll be amazed with the number of tables and
machines with roulettes they have there.

Now, "game of chance..." chance and games had always been related, I don't
see a reason to diminish my question with these comments or rephrase my
definition of an even number, more when as per your so called colaboration I
know nothing about math... no help at all.

Leo.
 
H

Harlan Grove

Leo Rod said:
"That's just one game of chance, a game not many gamblers bother playing"

Have you been in Vegas recently?
Click to expand...
....

OK, I'll correct that: not played by intelligent gamblers.
. . . or rephrase my definition of an even number, more when as per your
so called colaboration I know nothing about math... no help at all.
Click to expand...

So you know nothing about math but expect to be able to do what, exactly,
with regard to roulette using Excel? And even if you didn't know much if any
math, why should it come as a surprise that Excel would be geared towards
math rather than gambling or more specifically roulette? Or do you mean your
only understanding of Odd and Even numbers comes from roulette?

Your 'definition' of even numbers is highly specialized and not widely used
except among gamblers who play roulette. Are you trying to develop a system
for winning at roulette, i.e., beating the odds? The Las Vegas casinos have
grown very, very rich catering to people who believe they've found escape
hatches from basic mathematics and statistics.
 
L

Leo Rod

No Mr. Grove, I just want to play roulette for free and kill spare time
while practicing some Excel.

Have a great day.
 
J

JE McGimpsey

andycat said:
There are plenty of other people out here who can provide accurate
help without resorting to childish name calling.
Click to expand...

As opposed to those who resort to snide condescension...
 
S

Stan Brown

Thu said:
Is there an specific reason why Excel have zero as even or to define this
function to be "#Value" or "#N/A"??
Click to expand...

0 is an even number. I'm sorry that's inconvenient for your
application, but Excel is correct in this case.
 
Top