Even and Odd

G

Guest

IS there a keyword in Visual Basic that recognizes whether a number is odd or
even.
Could you explain a little more on how to call these functions and an example
of code for them. How to set a reference to the Analysis toolpak for
iseven(), isodd()? Thanks in advance.
 
J

JE McGimpsey

It's generally more efficient just to use the Mod function:

Const nTest As Long = 42
Dim bIsOdd As Boolean
Dim bIsEven As Boolean
bIsOdd = nTest Mod 2 = 1
bIsEven = nTest Mod 2 = 0
MsgBox "bIsOdd: " & bIsOdd & vbNewLine & "bIsEven: " & bIsEven
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

odd and even number conditional formatting 3
Identify even (or odd) rows without toolpak and 'ISEVEN'/'ISODD' ? 3
How do I count odd numbers in a range? 4
Even and Odd 3
odd or even number 3
Reference to functions in Conditional Formatting 2
Help with Formula using Analysis ToolPack Function ISODD 1
Need to group Odd and Even numbers 1

Top