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.