View Single Post
  #1   Report Post  
Abi
 
Posts: n/a
Default =IF Statement formula or conditional formatting

I'm trying to solve a problem with a formula I'd like to write. I think I'm
doing it correctly, but it keeps giving me a circular reference error.

What I want:
If data entry in the cell is 1, make the cell read One-Man, otherwise make
the cell read Two-Man. (It will only ever be 1 or 2.)

What I was trying to use:
=IF(B205=1,"One-Man","Two-Man")
or some iteration of that.

Maybe I should be using a different formula function. I'm not sure. Help!