Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I am looking at values in one column to see if they start with specific 2 or
3 char. then I want to have a result value of 1 of three words. I.E., if the value contains ab at the beginning then the result in the next column will be AB, if the value contains abc at the beginning then the result will be abc, if the value contains def in the beginning then I want the result to be def. I tried using 3 if statements. That did not work. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Nested "IF" Statement | Excel Worksheet Functions | |||
Nested IF statement with VLOOKUP | Excel Discussion (Misc queries) | |||
:confused: Nested if then else statement | Excel Worksheet Functions | |||
Problem with nested IF_OR statement | Excel Worksheet Functions | |||
7+ nested if statement? | Excel Worksheet Functions |