even numbers

[polilop]

how can i check if a variable is an even number?

 

[Mark J. McGinty]

how can i check if a variable is an even number?

Assuming the variable identifier is 'n':

If (n Mod 2) = 0 Then ...

Mod is the VBS modulus operator, it returns the remainder of a division
operation.


-Mark

 

[polilop]

did not know that,
thank you.

Assuming the variable identifier is 'n':

If (n Mod 2) = 0 Then ...

Mod is the VBS modulus operator, it returns the remainder of a division
operation.


-Mark

 

[Dave Anderson]

If (n Mod 2) = 0 Then ...

Alternatively:
If n/2 = n\2 Then ...



--
Dave Anderson

Unsolicited commercial email will be read at a cost of $500 per message. Use
of this email address implies consent to these terms. Please do not contact
me directly or ask me to contact you directly for assistance. If your
question is worth asking, it's worth posting.

 

[Mark J. McGinty]

Alternatively:
If n/2 = n\2 Then ...

But that incurs overhead for an integer division op, plus a floating point
division op, then a comparison of floats (after implicit type promotion of
the integer expression.)

Mod is just one integer division op, (unless n happens to be floating point)
and then integer comparison. Further, Mod will tolerate Empty as the first
operand.

Lastly... well "intuitive" is in the eye of the beholder, so I'll skip the
rest.


-Mark