View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Scott R Scott R is offline
external usenet poster
 
Posts: 54
Default If formaula ODD and EVEN

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