| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
if a cell = a particular letter or even contains that letter
=IF(M22="all","a",IF(M22="e","r","a"))
Notice the "e", how can I insert the following: ....If m22 contains "e" anywhere,"r","a")) Thanks Brian |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I get a letter in one cell ito equal a number in anotherl.. | Excel Discussion (Misc queries) | |||
| Capitalize first letter when type a name in each cell. | Excel Worksheet Functions | |||
| GET.CELL | Excel Worksheet Functions | |||
| Function / formula to be used if cell contains a letter. | Excel Worksheet Functions | |||
| VLookup resulting in a blank cell... | Excel Worksheet Functions | |||
Threaded Mode
