| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
if function, multiple characters from right
I am trying to enter a phrase in a certain cell if one of the last 3
characters in another cell is a "T". What I have so far is =if(right(z6,1)="T","TEMP CYCLED")), but it will only place "TEMP CYCLED" in cell A26 if the last character in Z6 is T. I need it recognize any of the last 3 characters as T and return "TEMP CYCLED" in cell A26. Thanks Jim |
|
#2
|
|||
|
|||
|
Try this...
=IF(ISERROR(FINDB("T",z6,1)),"",IF(LEN(z6)-FINDB("T",z6,1)<=3,"TEMP CYCLED","")) "jimqual" wrote: I am trying to enter a phrase in a certain cell if one of the last 3 characters in another cell is a "T". What I have so far is =if(right(z6,1)="T","TEMP CYCLED")), but it will only place "TEMP CYCLED" in cell A26 if the last character in Z6 is T. I need it recognize any of the last 3 characters as T and return "TEMP CYCLED" in cell A26. Thanks Jim |
|
#3
|
|||
|
|||
|
Dosent seem to work
"Naomi" wrote: Try this... =IF(ISERROR(FINDB("T",z6,1)),"",IF(LEN(z6)-FINDB("T",z6,1)<=3,"TEMP CYCLED","")) "jimqual" wrote: I am trying to enter a phrase in a certain cell if one of the last 3 characters in another cell is a "T". What I have so far is =if(right(z6,1)="T","TEMP CYCLED")), but it will only place "TEMP CYCLED" in cell A26 if the last character in Z6 is T. I need it recognize any of the last 3 characters as T and return "TEMP CYCLED" in cell A26. Thanks Jim |
|
#4
|
|||
|
|||
|
Jim,
Put this in A26: =IF(ISERROR(FIND("T", Z6,LEN(Z6)-2)),"","Temp cycled") -- Earl Kiosterud mvpearl omitthisword at verizon period net ------------------------------------------- "jimqual" wrote in message ... I am trying to enter a phrase in a certain cell if one of the last 3 characters in another cell is a "T". What I have so far is =if(right(z6,1)="T","TEMP CYCLED")), but it will only place "TEMP CYCLED" in cell A26 if the last character in Z6 is T. I need it recognize any of the last 3 characters as T and return "TEMP CYCLED" in cell A26. Thanks Jim |
|
#5
|
|||
|
|||
|
Earl,
Thanks, works like a charm Jim "Earl Kiosterud" wrote: Jim, Put this in A26: =IF(ISERROR(FIND("T", Z6,LEN(Z6)-2)),"","Temp cycled") -- Earl Kiosterud mvpearl omitthisword at verizon period net ------------------------------------------- "jimqual" wrote in message ... I am trying to enter a phrase in a certain cell if one of the last 3 characters in another cell is a "T". What I have so far is =if(right(z6,1)="T","TEMP CYCLED")), but it will only place "TEMP CYCLED" in cell A26 if the last character in Z6 is T. I need it recognize any of the last 3 characters as T and return "TEMP CYCLED" in cell A26. Thanks Jim |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how do i reference multiple rows/columns with one function? | New Users to Excel | |||
| Product Function in Pivot Tables from Multiple Consolidation Range | Excel Worksheet Functions | |||
| SumIf Function using multiple criteria | Excel Worksheet Functions | |||
| Multiple OR function | Excel Worksheet Functions | |||
| Multiple Worksheets and Print Merge function | Excel Discussion (Misc queries) | |||
Linear Mode
