+ Reply to Thread
Results 1 to 4 of 4

Excel 2007 : Giving 15% discount

Hybrid View

  1. #1
    Forum Contributor GuruWannaB's Avatar
    Join Date
    01-24-2008
    Location
    An hour due East of Cowtown Ohio
    MS-Off Ver
    2010
    Posts
    421

    Re: Giving 15% discount

    Can you upload a spreadsheet to show an example?

  2. #2
    Forum Contributor GuruWannaB's Avatar
    Join Date
    01-24-2008
    Location
    An hour due East of Cowtown Ohio
    MS-Off Ver
    2010
    Posts
    421

    Re: Giving 15% discount

    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)

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1