Thread: Function for odd even numbers
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Teethless mama Teethless mama is offline
external usenet poster
  
Posts: 3,718
Default Function for odd even numbers
=CHOOSE(ISODD(A1)+1,"even","odd")


"petedacook" wrote:

Is there a function to determine if a cell has odd or even numbers? This
would be used in an "IF" statement.

Thanks,

pete K
Reply With QuoteReply With Quote