+ Reply to Thread
Results 1 to 4 of 4

Reverse Multiply Percentage

  1. #1
    Registered User
    Join Date
    12-15-2019
    Location
    indo
    MS-Off Ver
    2016
    Posts
    2

    Reverse Multiply Percentage

    hi guys,

    i got problem while doing reverse calculation for percentage
    based on other articles i can learn reversing percentage by formula that is given.
    but in my cases there is tax 2 (see attachment given) which 5% tax is charge after the amount is reduce by certain number (60)
    please help for the reverse formula from the file attach

    thanks a million
    Attached Files Attached Files
    Last edited by boy_42; 12-19-2019 at 05:48 AM. Reason: already solved

  2. #2
    Valued Forum Contributor saravnepali's Avatar
    Join Date
    01-14-2019
    Location
    Sydney Australia
    MS-Off Ver
    2010
    Posts
    447

    Re: Reverse Multiply Percentage

    I did some simplification
    =100*Amount+60*tax2/(tax1+tax2+100)
    Formula: copy to clipboard
    Please Login or Register  to view this content.
    If you think someone helped you, click on the "* Add Reputation" as a way to say thank you.

    If your problem is solved, go to Thread Tools and select Mark This Thread Solved

  3. #3
    Valued Forum Contributor saravnepali's Avatar
    Join Date
    01-14-2019
    Location
    Sydney Australia
    MS-Off Ver
    2010
    Posts
    447

    Re: Reverse Multiply Percentage

    IF its likely that the sales amount is less than 60 then
    Formula: copy to clipboard
    Please Login or Register  to view this content.

  4. #4
    Registered User
    Join Date
    12-15-2019
    Location
    indo
    MS-Off Ver
    2016
    Posts
    2

    Re: Reverse Multiply Percentage

    bravo, you really make my day. thanks a lot

+ 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. Deducting percentage, calculate what percentage needs to be added to reverse
    By HereComesTheBoom in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 03-15-2019, 05:47 AM
  2. Multiply a value to a range of percentage
    By ladyville21 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 03-09-2019, 11:46 AM
  3. Formula to multiply by a certain percentage if above or below
    By Systic in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 10-10-2017, 08:28 PM
  4. [SOLVED] Multiply number by percentage
    By RoTrKO in forum Excel Formulas & Functions
    Replies: 18
    Last Post: 04-29-2016, 09:46 AM
  5. NVQ Reverse Percentage
    By gillmacca in forum Excel General
    Replies: 0
    Last Post: 08-09-2012, 02:52 PM
  6. Multiply a certain percentage in Excel
    By guiri in forum Excel General
    Replies: 1
    Last Post: 06-07-2007, 09:48 PM
  7. [SOLVED] How do I multiply cell value by percentage?
    By Kelly P. in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 10-27-2005, 03: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