Originally Posted by ingust

Hi all
can anyone help me place the following in an EXCEL single cell if possible ,

if b1 = < 1250 then divisor = 4 , if b1 = > 1251 and b1 = < 1450 then divisor=3 , if b1 = > 1451 and b1 = < 1600 then divisor = 2 , if b1 > 1600 then divisor = 1.5 ,

Regards

Ingust