| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
=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! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Formula Dependant Conditional Formatting | Excel Discussion (Misc queries) | |||
| Conditional formatting based on if statement. | Excel Worksheet Functions | |||
| conditional formatting conflict? | Excel Worksheet Functions | |||
| Copy conditional formatting across multiple rows? | Excel Discussion (Misc queries) | |||
| Conditional formatting not available in Excel | Excel Discussion (Misc queries) | |||
Threaded Mode
