Thread: even
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Mike H Mike H is offline
external usenet poster
  
Posts: 11,501
Default even
Use the MOD function

myvariable = 9
If (myvariable Mod 2) 0 Then
MsgBox "Odd"
Else
MsgBox "Even"
End If

Mike

"ranswert" wrote:

How do I find out if a variable is even?
Thanks
Reply With QuoteReply With Quote