What I have is a column with 6 characters that can either be all alpha or 1
alpha with 5 numeric characters. What I need to do is examine cell and if
the last five characters are numberic compute the cost. How would I make a
condition to do that.

part # QTY ID Rate Extension
23456 23 JJones .34
39485 20 J23494 .59 11.80
96874 30 J23494 1.19 35.70
16349 50 DDavis .59