Changing a formula in a cell by entering a number in another cell, is it possible?

for your first question, maybe something like This in S1,2,3,4...

[B]=IF(AND(B20>0,B20<=30),0.3,IF(AND(B20>30,B20<=50),0.4)).....[/B

Sorry but i don't understand your second question...