+ Reply to Thread
Results 1 to 2 of 2

Percentage Discount Total

  1. #1
    Registered User
    Join Date
    04-21-2006
    Posts
    4

    Percentage Discount Total

    Hi All,

    Can anyone help me with the following.

    I have the formula =SUM(D2*(20/100)) which gives me the discount value of cell D2 i.e if D2 = 10 then the SUM = 2

    But I want the formula to work out the total minus the sum ie.

    10 - 20% = 8

    I hope ive made this clear, maybe im just going about it the wrong way.
    Regards

    Mark

  2. #2
    Forum Contributor kraljb's Avatar
    Join Date
    05-26-2004
    Location
    Illinois
    MS-Off Ver
    2007 (recent change)
    Posts
    256
    Try this...
    =D2-SUM(D2*(20/100))

    Taking the Original Sum and then subtracting it by the discount amount will give you the remainder.

+ 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