Need help: how would I do a formula that would do a discount price if you get more than a certain number if items for example. if you buy an item that is 12.95 each but if you buy more than 15 they would be 10.95 each.
Need help: how would I do a formula that would do a discount price if you get more than a certain number if items for example. if you buy an item that is 12.95 each but if you buy more than 15 they would be 10.95 each.
you could do it many ways, with a sumproduct or an if statement depending on the complexity.
for an IF it would look something like this... =IF(B2<16,B2*12.95,B2*10.95) is the simplest way I can think of (where B2 is the quantity bought).
Make contributors happy, click on the "* Add Reputation" as a way to say thank you.
Sam Capricci
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks