If formaula ODD and EVEN

S

Scott R

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

odd and even addresses 3
Countif function for Even and Odd numbers 34
Even and Odd 1
odd and even number conditional formatting 3
Sort by even and odd digits and copy to separate worksheet 3
odd or even number 3
Determine if number is even or odd 1
Page Numbers Different Odd and Even Pages 4

Top