Can you upload a spreadsheet to show an example?
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.
=If(Quantity of Items>9, Total * 0.85, Total)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks