I have tried a vlookup, but I think there has to be something better.

I have columns D2-D250 with various quantities then I have column F2-F250 blank. In column F2-F250 i want to populate pricing that corresponds to the quantities in D2-D250 based on the following guide lines.

If quantity in column D is between 1-10 the price that should populate in column F is 7.50.

If quantity in column D is between 11-100 the price that should populate in column F is 15.00.

If quantity in column D is 101 or greather the price that should populate in column F is 75.00.

So if D2 is 50, F2 should display a price of 15.00.

If D3 is is 102, F3 should display a price of 75.00 and so on.

help would be greatly appreciated.