Results 1 to 4 of 4

Formula for Discount Percentage

Threaded View

Ali H Formula for Discount... 09-17-2012, 09:24 PM
NickyC Re: Simple Formula 09-17-2012, 09:30 PM
Ali H Re: Simple Formula 09-17-2012, 09:33 PM
arlu1201 Re: Simple Formula 09-18-2012, 04:05 AM
  1. #1
    Registered User
    Join Date
    09-17-2012
    Location
    Melbourne
    MS-Off Ver
    Excel 2003
    Posts
    2

    Formula for Discount Percentage

    Hey Guys,

    Can anyone help me with a formula? Basically what i’m trying to achieve is:

    If the total of a cell is greater then x, minus a per centage from the amount it is over by.

    So for example if x is 7500, cell total is 7600, minus 50%, total should be 50.

    Can anyone help?
    Last edited by Ali H; 09-18-2012 at 07:19 PM.

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