Home

Microsoft Excel [email protected]

Microsoft Excel 2007

Microsoft Excel 2003

Forums

Microsoft Excel 2003 Functions and Formulas

Determine if a Number is Odd or Even

Summary: A quick Excel 2003 worksheet function for determining whether or not a cell value is odd or even.

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:

=iseven(VALUE)

VALUE can be a number, cell, result of a formula, etc. Returns TRUE if VALUE is even, FALSE otherwise.

=isodd(VALUE)

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:


A B
1 5 =isodd(23)
2 22 =iseven(a2)
3 69 =isodd(a1+a3)

The results:

B1: TRUE
B2: TRUE
B3: FALSE

Add: Del.icio.us | Digg | Furl | My Yahoo!

Last Modified on: July 23, 2008, at 9:43 A.M. EDT

Return to the Microsoft Excel 2003 Functions and Formulas page.

Print this tip.

- Subscribe!

Search the Site: