Greeting to all. I am using excel 2007 and I need help with a formula please.
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.
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.