if function, multiple characters from right

[jimqual]

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",""))

 

[jimqual7]

Dosent seem to work

Try this...

=IF(ISERROR(FINDB("T",z6,1)),"",IF(LEN(z6)-FINDB("T",z6,1)<=3,"TEMP
CYCLED",""))

 

[Earl Kiosterud]

Jim,

Put this in A26:

=IF(ISERROR(FIND("T", Z6,LEN(Z6)-2)),"","Temp cycled")

 

[jimqual]

Earl,

Thanks, works like a charm

Jim

Jim,

Put this in A26:

=IF(ISERROR(FIND("T", Z6,LEN(Z6)-2)),"","Temp cycled")