| Home |
| Search |
| Today's Posts |
|
|
|
#1
|
|||
|
|||
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) | |||
Hybrid Mode
