| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Three Conditions in one cell
Hello,
I have two columns. Column A has city names which include: Tri-Cities Tidewater Roanoke Richmond/Tidewater Richmond Knoxville Charlotte I need help writing a formula that will return CLR, CLK or CLC in Column B. Here is the break down: CLR if Tri-Cities, Tidewater, Roanoke, Richmond/Tidewater or Richmond CLK if Knoxville CLC if Charlotte Thanks so much for the help. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| if conditions in 2 cell correct then display third cell | New Users to Excel | |||
| Countif Conditions - Use of conditions that vary by cell value | Excel Discussion (Misc queries) | |||
| How do I make a cell refrence another cell based on conditions? | Excel Worksheet Functions | |||
| Cell value when conditions are met | Excel Worksheet Functions | |||
| Conditional formatting Based on cell A text with conditions in Cell B | Excel Discussion (Misc queries) | |||
Threaded Mode
