Function Macro to Determine Even or Odd Number

ID: Q43552

The information in this article applies to:

Microsoft Excel for Windows, versions 2.x, 3.0, 4.0, 4.0a, 5.0

SUMMARY

The following macro function determines if a given cell reference contains an odd or even number. Please note that the macro returns a #VALUE! error if the cell referred to does not contain a numeric entry and returns FALSE for all nonintegers (for example, 4.224).


   A1: ISEVEN
   A2: =ARGUMENT("number",1)
   A3: =RETURN(number/2=INT(number/2))

Additional query words: 2.00 2.0 2.01 2.10 2.1 3.0 4.0


Keywords          : 
Version           : 
Platform          : 
Issue type        :

Last Reviewed: March 12, 1999