| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
how do I use only 2 characters in a field in a formula
A1 B1
MH*97*14*80 96 I want to us the first 2 characters in A1 in a formula to place a value in B1 If the 1st 2 characters in A1="MH" or "AP" then B1=96 else B1=90 How do I write that formula? (How do I use any of the characters, for instance, if I want to use the 4th and 5th characters, 97)? Thanks. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
how do I use only 2 characters in a field in a formula
=IF(OR(LEFT(A1,2)={"AP","MH"}),96,90)
-- Gary''s Student - gsnu200909 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
how do I use only 2 characters in a field in a formula
rgarner wrote:
A1 B1 MH*97*14*80 96 I want to us the first 2 characters in A1 in a formula to place a value in B1 If the 1st 2 characters in A1="MH" or "AP" then B1=96 else B1=90 How do I write that formula? (How do I use any of the characters, for instance, if I want to use the 4th and 5th characters, 97)? Thanks. Look at IF(), LEFT(), MID() and OR() in the help file. =IF(OR(LEFT(A1,2)="MH",LEFT(A1,2)="AP"),96,90) |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to delete first three characters in all rows of a field | Excel Discussion (Misc queries) | |||
| Text Field in a cell changes characters | Excel Discussion (Misc queries) | |||
| Looking for alpha characters in a field | Excel Worksheet Functions | |||
| Removing characters from datetime field | Excel Discussion (Misc queries) | |||
| How do I remove the 1st 4 characters of a field in Excel? | Excel Worksheet Functions | |||
Hybrid Mode
