View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Gary''s Student Gary''s Student is offline
external usenet poster
 
Posts: 11,058
Default If formaula ODD and EVEN

They are functions:

=IF(ISODD(I2),"RHP","LHP")
--
Gary''s Student - gsnu200803


"Scott R" wrote:

Hi Guys, this is probably a real simple formaul but am having trouble with it
and have looked thru prev threads but cannot find anything. I have a list of
page numbers and want a column next to it to say whether they are a LHP or
RHP. My formua is =IF(I2=ISODD,"RHP","LHP") but i only get LHP as an answer
regardless of whether it is an odd or even number??
any suggestions would be appreciated..
thanks