Feb 6, 2004 #1 gshock Technical User Joined Oct 28, 2002 Messages 11 Location CA Trying to find a way to validate a number by determining whether the number is odd or even (a true or false argument). Help is kindly appreciated. Thanks.
Trying to find a way to validate a number by determining whether the number is odd or even (a true or false argument). Help is kindly appreciated. Thanks.
Feb 6, 2004 #2 bluedragon2 IS-IT--Management Joined Jan 24, 2003 Messages 2,642 Location US if number/2 = integer of number /2 =A1/2=INT(A1/2) [Blue]Blue[/Blue] [Dragon] If I wasn't Blue, I would just be a Dragon... Upvote 0 Downvote
if number/2 = integer of number /2 =A1/2=INT(A1/2) [Blue]Blue[/Blue] [Dragon] If I wasn't Blue, I would just be a Dragon...
Feb 7, 2004 #3 KenWright Technical User Joined Mar 22, 2003 Messages 3,688 Location GB With your data in A1 =ISODD(A1) or =ISEVEN(A1) This will give you the TRUE/FALSE result. (May well be part of the Analysis Toolpak addin though (Not sure to be honest) Regards Ken............. ---------------------------------------------------------------------------- It's easier to beg forgiveness than ask permission ---------------------------------------------------------------------------- Upvote 0 Downvote
With your data in A1 =ISODD(A1) or =ISEVEN(A1) This will give you the TRUE/FALSE result. (May well be part of the Analysis Toolpak addin though (Not sure to be honest) Regards Ken............. ---------------------------------------------------------------------------- It's easier to beg forgiveness than ask permission ----------------------------------------------------------------------------