+ Reply to Thread
Results 1 to 2 of 2

Deducting percentage, calculate what percentage needs to be added to reverse

  1. #1
    Forum Contributor
    Join Date
    04-20-2017
    Location
    SWEDEN
    MS-Off Ver
    2016
    Posts
    117

    Deducting percentage, calculate what percentage needs to be added to reverse

    In the wb, a percentage is deducted from an original number, in this case 100.

    So -20% = 80

    I need to calculate what should be added percentage-wise to get back to 100, in the range from 1-30%

    https://www.excelforum.com/attachmen...1&d=1552642087
    Attached Files Attached Files

  2. #2
    Forum Expert BadlySpelledBuoy's Avatar
    Join Date
    06-14-2013
    Location
    East Sussex
    MS-Off Ver
    365
    Posts
    6,051

    Re: Deducting percentage, calculate what percentage needs to be added to reverse

    Do you mean what percentage of the number in column C needs to be added to bring it back to 100?

    If so the try this in D7 and copy down:
    =(B7-C7)/C7

    If not, give us a couple of manually generated expected results so we can better understand the requirement.

    BSB

+ 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. [SOLVED] Percentage added to a column help please
    By Hollywood691 in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 10-17-2016, 12:47 PM
  2. Formula to calculate value based on reverse percentage
    By aharvestofhealth in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 08-11-2012, 04:50 PM
  3. NVQ Reverse Percentage
    By gillmacca in forum Excel General
    Replies: 0
    Last Post: 08-09-2012, 02:52 PM
  4. Reverse GPA As Percentage To Calculate A Total Score
    By claudiopolis in forum Excel General
    Replies: 4
    Last Post: 10-21-2011, 08:28 AM
  5. Deducting a percentage from a number
    By mikeinitaly in forum Excel - New Users/Basics
    Replies: 1
    Last Post: 05-11-2011, 05:10 PM
  6. Need help with reverse percentage lookup?
    By takers in forum Excel General
    Replies: 1
    Last Post: 01-09-2011, 08:41 AM
  7. [SOLVED] percentage:how do I calculate the percentage change
    By Knowledge001 in forum Excel General
    Replies: 3
    Last Post: 11-25-2005, 02:40 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