Hi All
I hope you can help me if possible
I am trying to workout the correct formula to work out pricing on a customer order sheet
We have two pricing structures....price and sale
I want to be able to have a drop down on the product (which I have set using validation) so that it will fill out the price depending on what the pricing structure is set at
for example
if K16 = shovel and D9 = sale the value in L15 should be 12
if K16 = shovel and D9 = price the value in L15 should be 2
any help would be greatly appreciated as I am very new to doing formulae in excel
Thanks
Adam
tester.xlsx
Bookmarks