Proportional result linked to ranges of values.

[Leo37587]

Dear all,

I would like to achieve the following:

M= minimum Stock
Res= Quantity in Stock after sales
In= Quantity to reorder


IF Res= to between 0- 25% of M than In= M- 0
IF Res= to between 25- 50% of M than In= M-15% of M
IF Res= to between 50- 75% of M than In= M-30% of M
IF Res= to between 75%-100% of M than In= M-60% of M

Example:

M= 30

=IF(D4<???,"30",IF(D4????,"45", IF(D4<????,"41",IF(D4<????,"42"))))


Thanks in advance for you help. Don't hesitate asking further details.

Best regards.

[AndyLitch]

=IF(AND(A1>(0*B1),A1<=(0.25*B1)),B1-0,IF(AND(A1>(0.25*B1),A1<=(0.5*B1)),B1-(0.15*B1),IF(AND(A1>(0.5*B1),A1<=(0.75*B1)),B1-(0.3*B1),IF(AND(A1>(0.75*B1),A1<=(1*B1)),B1-(0.6*B1),"Error"))))

Assuming A1=Res and B1 = M