| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
IF statement that looks at part of the contents of a cell.
I have a need to make decisions based on the content of a cell that
contains an alphanumeric string such as P8072A. I want the ability to look at this cell and take an action based on what the first letter in the string is. For example, If the string is P8072A, I want cell G5 to be 2.5, and if the string is Y2898B then I want cell G5 to be 3.0 (because the first letter changed from P to Y). Is there a way to have excel look at letters in a cell to make logical decisions? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Looking Up Part Cell Contents | Excel Discussion (Misc queries) | |||
| #N/A if cell contents not part of an array | Excel Discussion (Misc queries) | |||
| Combining Cell Contents (Part 2) | Excel Discussion (Misc queries) | |||
| Can I use cell contents as part of a formula? | Excel Worksheet Functions | |||
| Web query - using cell contents as part of URL | Excel Programming | |||
![Jon[_21_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
