Hi all I can't seem to find out this type of problem. The problem is simple I have a price list and I need to find out how to take off 15% discount whenever the customer orders 10 or more
Hi all I can't seem to find out this type of problem. The problem is simple I have a price list and I need to find out how to take off 15% discount whenever the customer orders 10 or more
Can you upload a spreadsheet to show an example?
I am assuming you have a quantity of items purchasing column...and a column for adding up the costs for each item purchased. In your totals field...you basically need an if/then formula.
Please Login or Register to view this content.
A discount shown in the original price cells?
A discount in the same row in a cell of its own?
A discount against the entire order down in the order total somewhere?
Lots of different things your question could mean.
_________________
Microsoft MVP 2010 - Excel
Visit: Jerry Beaucaire's Excel Files & Macros
If you've been given good help, use the icon below to give reputation feedback, it is appreciated.
Always put your code between code tags. [CODE] your code here [/CODE]
?None of us is as good as all of us? - Ray Kroc
?Actually, I *am* a rocket scientist.? - JB (little ones count!)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks