Forgot to say that the current formula is working. I just want to add that if
it does find text instead of numbers, it needs to equal 1. It still needs to
equal 1 if it finds numbers less than 2 or greater than 16.

"evoxfan" wrote:

Below is my formula. The formula turns up an error when it finds text instead
of numbers. I would like it to return 1 when it finds text instead of numbers.

=IF(OR((0+MID(D42,2,2))*1<2,(0+MID(D42,2,2)16)),1 ,"Assign Division")

Thanks in advance for your help.