| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
If Statement to select a letter
Hello,
I have a column containing trap names which are labeled as a letter followed by and number and an "i" or "o" depending on whether its and inside trap or outside trap. So I want to make a column using an If statement that if the trap name column contains an "i" its value is inside and if not its value is outside. Example Data is shown below Column A Column B Trap Name Trap Location A1i If Column A contains "*i" value = inside, if not value = outside. A12o B12i Just wondering if this is possible and what my IF statement should read. Thanks |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
If Statement to select a letter
Try this if the "i" is always at the end:
=IF(RIGHT(A1,1)="i","Inside","Outside") Hope this helps. Pete "Karl" wrote in message ... Hello, I have a column containing trap names which are labeled as a letter followed by and number and an "i" or "o" depending on whether its and inside trap or outside trap. So I want to make a column using an If statement that if the trap name column contains an "i" its value is inside and if not its value is outside. Example Data is shown below Column A Column B Trap Name Trap Location A1i If Column A contains "*i" value = inside, if not value = outside. A12o B12i Just wondering if this is possible and what my IF statement should read. Thanks |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
If Statement to select a letter
you could try:
=IF(RIGHT(A1,1)="i", "inside", IF(RIGHT(A1,1)="o", "outside","")) "Karl" wrote: Hello, I have a column containing trap names which are labeled as a letter followed by and number and an "i" or "o" depending on whether its and inside trap or outside trap. So I want to make a column using an If statement that if the trap name column contains an "i" its value is inside and if not its value is outside. Example Data is shown below Column A Column B Trap Name Trap Location A1i If Column A contains "*i" value = inside, if not value = outside. A12o B12i Just wondering if this is possible and what my IF statement should read. Thanks |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
If Statement to select a letter
Thanks guys,
Exactly what I was looking for. Karl "Karl" wrote: Hello, I have a column containing trap names which are labeled as a letter followed by and number and an "i" or "o" depending on whether its and inside trap or outside trap. So I want to make a column using an If statement that if the trap name column contains an "i" its value is inside and if not its value is outside. Example Data is shown below Column A Column B Trap Name Trap Location A1i If Column A contains "*i" value = inside, if not value = outside. A12o B12i Just wondering if this is possible and what my IF statement should read. Thanks |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Creating ODBC link within SELECT statement | Excel Worksheet Functions | |||
| Creating ODBC link within SELECT statement | Charts and Charting in Excel | |||
| Creating ODBC link within SELECT statement | Charts and Charting in Excel | |||
| how do I make drop-down list select based on 1st letter entered? | Excel Discussion (Misc queries) | |||
| can i select from list by typing first letter of word? | Excel Discussion (Misc queries) | |||
Linear Mode
