FUNCTION: If partial text found at end of cell string then TRUE

[ChrisOK]

Having trouble finding formula that will look at the text within a cell and place a TRUE or FALSE -- if that text ENDS with an "X"
Example:
Column A holds various codes:
GHRYS
WJNCV
ABCDX
PRTYS

Position 1,2 & 4 would be FALSE and 3 would be TRUE since the text string ENDS with an X

I know these can be found w/ Conditional Formatting using the ENDING with -but I need an actual formula to be able to use it elsewhere within the ACL auditing system.

This one will find the cell if it has an X (anywhere) within the cell's text, but I need it to look only at the END of that text..
= ISNUMBER(SEARCH("X",A2))=TRUE

 

[Rick Rothstein]

Having trouble finding formula that will look at the text within a cell and place a TRUE or FALSE -- if that text ENDS with an "X"
Example:
Column A holds various codes:
GHRYS
WJNCV
ABCDX
PRTYS

Position 1,2 & 4 would be FALSE and 3 would be TRUE since the text string ENDS with an X

I know these can be found w/ Conditional Formatting using the ENDING with -but I need an actual formula to be able to use it elsewhere within the ACL auditing system.

This one will find the cell if it has an X (anywhere) within the cell's text, but I need it to look only at the END of that text..
= ISNUMBER(SEARCH("X",A2))=TRUE

Try this...

=RIGHT(A2)="X"

 

[ChrisOK]

Fantastic Rick! Thank you so much!