ExcelBanter - if function, multiple characters from right

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - if function, multiple characters from right (https://www.excelbanter.com/excel-worksheet-functions/17559-if-function-multiple-characters-right.html)

jimqual

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

Naomi

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

jimqual7

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

Earl Kiosterud

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

jimqual

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

All times are GMT +1. The time now is 04:48 AM.