Need a Formula

[Liverpool1959]

I pay my truck drivers by weight. I want to be able to enter the weight in a cell and what he makes for each delivery or pickup appear. Every cell in a column would have the same formula
Example. If he delivers 1-99 pounds he gets $6.38, 100-299 he gets $8.35, 300-399 he gets $10.86. All the way to 8000 Pounds and above he gets $63.66

So I want to able to use Column A Cell 1 down to Cell 40 and enter the weights and have the dollar figures appear

 

[Gordon K]

This formula should work. You will need to format column B for Currency with 2 decimal placesl

=((A1>0 )* (A1<100)) *6.38+ ((A1>99 )* (A1<300)) *8.35+ ((A1>299 )* (A1<400))*10.86+(A1>399)*63.66