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

Hi Robbie

Try this formula, it should be self explanatory as to how to change the multiplier to what you want:

=IF(A1<10.01,A1*10,IF(A1<50.01,A1*20,IF(A1<100.01, A1*30)))

Tony (OTPM)

with a little 'tweeking' i managed to get it working this is the final formula =IF(A2<9.99,A2*F2,IF(A2<99.99,A2*F3,IF(A2>100.01, A2*F4)))

What happens if A2 = 100?