Change the cell used for calculation to another cell if number is higher

[viranth]

Hello.

I'm trying to make a worksheet for pricing products for my company.

So far I'm using vlookup and it works great with drop down menu, so I can create one sheet for a certain product, then another sheet for another product. Just so I don't forget certain things when pricing.

But certain products have set values depending on how many items ordered.

So for example if ordering 1 item, the value is supposed to be 235.
But if ordering 5 items, the value is supposed to be 57.

How can I make the value in cell containing the 235 change after I type in 5.

Thank you for your help!

[Glenn Kennedy]

Please read the yellow banner at the top of the page and then post a SMALL sample workbook, showing what you expect to see and where you expect to see it.

[viranth]

Sorry, I attached an example file here.

[José Augusto]

Hi
try this
Suppose K12 is size and L12 is quantity
use this to get the price

Please Login or Register  to view this content.

See the file

[viranth]

Thank you so much, José Augusto.

This is what I'm looking for. Now I just need to figure out how to change the layout and various things like that.

Very fun and educational to do this, thank you so much again! :D