I have a large excel spreadsheet that I need to find either all even numbers
or all odd numbers in a column. IIs there a simple function for doing this?

With values in col. A, put this in B1 and fill down:

=IF(ISODD(A1),"Odd","Even")

HTH
Jason
Atlanta, GA

-----Original Message-----
I have a large excel spreadsheet that I need to find
either all even numbers
or all odd numbers in a column. IIs there a simple
function for doing this?
.

=MOD(A1,2) will return 0 for even numbers, 1 for odd numbers.

On Thu, 27 Jan 2005 05:41:04 -0800, "whouser"
wrote:

I have a large excel spreadsheet that I need to find either all even numbers
or all odd numbers in a column. IIs there a simple function for doing this?

Note: the Analysis ToolPak add-in must be loaded to access the ISODD or
ISEVEN Functions.

ToolsAdd-insATP checked.


Gord Dibben Excel MVP

On Thu, 27 Jan 2005 05:58:06 -0800, "Jason Morin"
wrote:

With values in col. A, put this in B1 and fill down:

=IF(ISODD(A1),"Odd","Even")

HTH
Jason
Atlanta, GA

-----Original Message-----
I have a large excel spreadsheet that I need to find
either all even numbers
or all odd numbers in a column. IIs there a simple
function for doing this?
.