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

The formula to use is =IF(B1<=1250,4,IF(B1<=1450,3,IF(B1<=1600,2,1.5)))

thank you Glenno for replying , but i still cant get it to work ,

here is what iam trying to do


distance factor =( 1.5 , 2 , 3 , 4 ) depending on the distance will =one of those 4 numbers

then that factor is divided into ( weight/limit ) / by one of the above factors

weight diff = ( wgt / limwgt ) / distance factor ,

regards

Ingust

thanks again Glenno
works ok now that i have copied in correctly ,

Regards
Ingust

__________________
shortodds