| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
check the value in cell
Dear Sirs,
I do not know how to solve a problem with excel. I want to check the value in cell 'A2' (3010-401/15/2013). if 'A2' has 3010 then in 'B2' should be 'street', if it has 3011, than should be 'block', if is the 3012, it should be a 'town' many thanks ! |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
check the value in cell
Hello,
Try this formula in cell B2: =CHOOSE(1+MID(A2, 4, 1), "street", "block", "town") |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| check or uncheck a check box based on a cell value | Excel Discussion (Misc queries) | |||
| Copy and move check box (check boxes) with new cell link? | Excel Worksheet Functions | |||
| Cannot check the check mark box in cell | Excel Worksheet Functions | |||
| check to see if a cell is blank if not populate adjacent cell wit. | Excel Discussion (Misc queries) | |||
| Check if Conditional Format is True or False / Check cell Color | Excel Worksheet Functions | |||
![Marin[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
