Some Microsoft Excel 2003 spreadsheets need to calculate whether or not a value entered in a particular cell is an odd or even number. To determine this, use the =isodd and =iseven functions.
Before using these functions, you must have previously installed the Analysis ToolPak Add-In.
The syntax is simple:
VALUE can be a number, cell, result of a formula, etc. Returns TRUE if VALUE is even, FALSE otherwise.
VALUE can be a number, cell, result of a formula, etc. Returns TRUE if VALUE is odd, FALSE otherwise.
For example, given the following spreadsheet:
1 5 =isodd(23)
2 22 =iseven(a2)
3 69 =isodd(a1+a3)
Press the "print" button on your browser or select "File" - "Print" to print this tip. Then, return to Microsoft Excel 2003 Functions and Formulas - Determine if a Number is Odd or Even.
Standard disclaimer applies - Read http://tipsforspreadsheets.com/copyright-disclaim.html.