+ Reply to Thread
Results 1 to 2 of 2

Calculate discount but ignore highest value

  1. #1
    Registered User
    Join Date
    07-22-2011
    Location
    Sydney
    MS-Off Ver
    Excel 2010
    Posts
    38

    Question Calculate discount but ignore highest value

    Hi guys, Need some help fixing this formula.

    Please Login or Register  to view this content.
    Essentially Im calculating a discount for items added (but only if there is more than 1)
    Discount does not apply for highest value item.
    The formula seems to work until i have 2 items of the same value.

    If there is 2 items of same price, only 1 gets a discount.

    Any tips on how i can fix this?

    Thanks in advance for your time!

  2. #2
    Registered User
    Join Date
    05-05-2014
    Location
    Hyderabad
    MS-Off Ver
    Excel 2010
    Posts
    1

    Re: Calculate discount but ignore highest value

    Hi,
    Could you share some sample data?

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Conditional Formatting - Lowest 3 / Highest 3 - Ignore 0 or Blanks
    By mycon73 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 04-14-2017, 11:08 AM
  2. How to calculate discount in PowerPivot??
    By mrxlsx in forum Excel General
    Replies: 1
    Last Post: 06-13-2015, 12:16 AM
  3. Ignore Highest and Lowest Values
    By DanRandles in forum Excel General
    Replies: 7
    Last Post: 09-30-2013, 06:23 PM
  4. Macro to calculate discount
    By amarjeet.it in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-22-2013, 08:55 AM
  5. calculate the value of a mortgage purchased at a discount
    By Jim@cch in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 09-06-2005, 02:05 AM
  6. calculate the value of a mortgage purchased at a discount
    By Jim@cch in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 09-06-2005, 12:05 AM
  7. [SOLVED] calculate the value of a mortgage purchased at a discount
    By Jim@cch in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 06-01-2005, 11:05 PM

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