Essentially, what I am trying to do is to create a cell that will pull from a mid range of numbers such as 40030-090-01 and if the middle range is greater than 080 it will return 08, if it is less than 080 it will look at the third data set 01 and return the 01 figure. Here is what I have so far =IF(NUMBERVALUE(MID(B961,8,2))>50,NUMBERVALUE(MID(B961,8,1)),RIGHT(B961,2)) It just doesn't seem to be giving me what I need. Any help would be appreciated. Thank you,