Formula for Reverse Percentage - Net Amount

Thanks Thanks:  0
Likes Likes:  0
Results 1 to 5 of 5

Thread: Formula for Reverse Percentage - Net Amount

  1. #1
    New Member
    Join Date
    Nov 2004
    Posts
    2
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Formula for Reverse Percentage - Net Amount

     
    I need to know how to do a reverse percentage look up.

    Example:

    What is 7% of $100 and what is the net amount

    $100 (includes 7%)

    So the formula I need will provide the following:

    Net Amount:$93.46
    7% = $6.54
    Total = $100

    Thanks muchly ~ Eden

  2. #2
    Board Regular
    Join Date
    Feb 2002
    Location
    Phoenix, Arizona
    Posts
    1,711
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Formula for Reverse Percentage - Net Amount

    Welcome to the board!

    Net amount = (100/1.07)
    7% = (100-(100/1.07))

    ******** ******************** ************************************************************************>
    Microsoft Excel - Book1___Running: 11.0 : OS = Windows XP
    (F)ile (E)dit (V)iew (I)nsert (O)ptions (T)ools (D)ata (W)indow (H)elp (A)bout
    =

    A
    B
    C
    D
    1
    Total100
    2
    Percent7%
    3
    Net 93.46
    4
    % of net 6.54
    Sheet1

    [HtmlMaker 2.42] To see the formula in the cells just click on the cells hyperlink or click the Name box
    PLEASE DO NOT QUOTE THIS TABLE IMAGE ON SAME PAGE! OTHEWISE, ERROR OF JavaScript OCCUR.

  3. #3
    MrExcel MVP Aladin Akyurek's Avatar
    Join Date
    Feb 2002
    Location
    The Hague, NL
    Posts
    81,469
    Post Thanks / Like
    Mentioned
    10 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Formula for Reverse Percentage - Net Amount

    =100/(100%+7%)

  4. #4
    Board Regular
    Join Date
    Aug 2002
    Posts
    395
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Formula for Reverse Percentage - Net Amount

    If your input data includes the percentage , then it is resulted from this calculation : Original amount X(1+percentage) that is Net amount X (1+R%)
    hence the reverse would be Grossup divided by )1+R%

    Say in Column A the amount is 100
    then in column B you enter =A/(1+7%)
    the result would be 93.46
    in column C the formulka is B*7%
    the result will be 6.54
    and column D is B+c

    and then you can copy the coloumns and use the paste special and transpose them in the format your are looking for

    Hope this help

  5. #5
    New Member
    Join Date
    Nov 2004
    Posts
    2
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

      
    Travis - you are my hero!!!!!!!

    Thanks muchly !!!

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

 

 
DMCA.com