Bernie The Bass
03-01-2007, 02:54 PM
Hi - does anyone know what code I need to use (preferably in excel) to automatically calculate the price of some goods, dependent upon the quantity ordered. ie:
if the order is for 1 - 10 units, then price = £x
if the order is for 11-25 units, then price =£y
if the order is for 26-100 units, then price =£z....etc...
OR put another way....
if I enter say 7 in the quantity cell, it will pick up price band A and calculate the total automatically
if I enter say 12 in the quantity cell, it will pick up price band B and calculate the total automatically...and so on.
Many thanks.
if the order is for 1 - 10 units, then price = £x
if the order is for 11-25 units, then price =£y
if the order is for 26-100 units, then price =£z....etc...
OR put another way....
if I enter say 7 in the quantity cell, it will pick up price band A and calculate the total automatically
if I enter say 12 in the quantity cell, it will pick up price band B and calculate the total automatically...and so on.
Many thanks.