i am trying to create a spreadsheet of stock, within the spreadsheet i have different products and different prices for bulk ordering, i am trying to find a formula that will alow me to put in the required amout needed and if its over a certain value then use a different price and give me a total, however i have 3 different prices i can choose from i.e. order 1 and you get it a £**.** order 10+ and you get it at £**.** and order over 100 and you get it at £**.**.
please help im at my whits end with this one

robbie