help with if then formula - URGENT

  • Thread starter Thread starter craggergirl
  • Start date Start date
C

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
 
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
 
Back
Top