View Single Post
  #1   Report Post  
jenn
 
Posts: n/a
Default "E" for even numbers. "O" for odd numbers.

hi there

I need a formula that will produce "E" or "O" for even or odd numbers in
columnA. I have tried messing around with =if(A1=iseven,"E","O") but not to
much success. What am i missing here?
Thanks!