if formula help

[Cayliff]

Hello, I am trying to find a formula that will do this I have rows that has 9k100tkh0gs 100, 9k100tkh0gs 250, and 9k100tkh0gs 500, I want a formula that will look only at the 100, 250 or 500 in a cell. for example I have 20 rows with 9k100 100, 9k100 250 9k100 500, 9k150 100, 9k150 250, 9k150 500,and so on.


I want the formula to put "OK" next to the cells that has 100 or 250 and "NON STOCK" by the ones that has 500

any help will be appreciated.

Thanks

[bebo021999]

Try this:
=IF(--RIGHT(A1,3)=500,"NON STOCK","OK")

[Cayliff]

Thanks that did it

[Taislin]

Dont forget to mark this thread as SOLVED please.