IF String value the....

[jolene]

I am trying to calculate a formula based on the right most character in a
cell.
For instance if a cell had a entry like Baker T. I want to calculate a
formula if the T is there and another if the T is missing.
Thanks in advance

 

[Frank Kabel]

Hi
use
=IF(RIGHT(A1,1)="T","do something","something else")

 

[Dave Peterson]

=if(right(a1,1)="t","it ends with T","nope it doesn't")