Automated Pricing Schedules from set values

[Corner12]

I have to make 110 manual entries for every type of material we sell.
Attached is an example of what I am trying to accomplish. Automating even part of this would be a huge help!
Thanks in advance!

[Pete_UK]

Obtained by direct substitution, put this in B2:

=IF($A2*B$1>3200,0.98,IF($A2*B$1>1600,1.18,IF($A2*B$1>599,1.25,IF($A2*B$1>290,1.47,1.77))))*$A2*B$1+IF($A2*B$1>1599,1.18,IF($A2*B$1>799,1.3,IF($A2*B$1>248,1.4,IF($A2*B$1>159,1.5,IF($A2*B$1>100,1.7,IF($A2*B$1>50,1.85,IF($A2*B$1>29,2,2.62)))))))*$A2*B$1+$A2*0.75+15

then copy across and down as required.

Hope this helps.

Pete

[Corner12]

That's Awesome!!!!!!!!!
You made my day!
Thank You!!!!