Microsoft KB Archive/43552

{|
 * width="100%"|

Function Macro to Determine Even or Odd Number

 * }

-

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(&quot;number&quot;,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 :

Technology :