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?
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"
<[email protected]> 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.
Tools>Add-ins>ATP checked.
Gord Dibben Excel MVP
On Thu, 27 Jan 2005 05:58:06 -0800, "Jason Morin"
<[email protected]> 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?
>>.
>>
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks