HI, I need the function formula something where:
If Value in A1 as "002-2-12341-8 " ,B1 change to "2" and C1 show "NORMAL"
If Value in A1 as 212-1-45342-9 ,B1 change to "1" and C1 show "EXTRA"
NOTE: THE NUMBER MAY BE ANOTHER NUMBER
THE DIGIT 1 MEAN EXTRA
THE DIGIT 2 MEAN NORMAL
Bookmarks