=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?