Formula for Reverse Percentage - Net Amount

Thanks:  0
Likes:  0

# Thread: Formula for Reverse Percentage - Net Amount

1. ## 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. ## 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
 B3B4 =

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. ## Re: Formula for Reverse Percentage - Net Amount

=100/(100%+7%)

4. ## 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.
Travis - you are my hero!!!!!!!

Thanks muchly !!!

## User Tag List

#### Posting Permissions

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