help with if then formula - URGENT

[craggergirl]

In my spreadsheet have a colum with contract numbers in it (Column D).
A contract is deemed expired or current based on the alpha character
at the end of the number. So,

1060.1594E in D2 means the contract is expired and 1060.1594C in D2
means the contract is current. In A1 I want a formula that says if D2
is expired put an "X" in A1. How do I create a formula that will do
this? I tried this in A1:

=if(d2="?E","X","")

but that didn't work.

Not very good with formulas, so any help is greatly appreciated!!
Thanks so much

 

[Ed from AZ]

=IF(RIGHT(D2,1)="E","X","")

Ed

 

[craggergirl]

Ed-Thank you! This worked perfectly!! I have so much to learn!!

 

[Ed from AZ]

My pleasure! It's nice to be on the other end of the help for a
change! 8>)

Come back here often to read and ask questions - it's how I've learned
most of what I know of Excel.

Ed