How about this instead of an IF stmt? =A1/LOOKUP(A1,{0,101,501},{52,250,500})