Function for Inverse Percentage

  • Thread starter Thread starter Steven
  • Start date Start date
S

Steven

Is there a function that can calculate an inverse
percentage e.g. the formula would be =1/(100%-%figure that
you enter)

e.g. =1/(100%-15%) = 1.1765

Any help?
 
In b1 put =1/(1-A1)
in a1 enter the percent you want to use and it will calculate it for
you

you can also use something like

=a1/(a1-b1)

put your value in a1 your percentage in b1 and the formula in c1

Randall
 
Thanks for your reply. I have managed to put the formula
in but I was wondering if there was a function in Excel
that would do this for you i.e. you enter the % and does
the formula for you.

Do you know if a function like this exists?
 
No, but it would be trivial to make a User Defined Function:

Public Function InversePercent(ByVal dIn As Double) As Variant
If dIn = 1 Then
InversePercent = CVErr(xlErrNum)
Else
InversePercent = (1 - dIn) ^ -1
End If
End Function


Call from the worksheet as

=InversePercent(15%) ===> 1.1765


If you're not familiar with macros or UDFs, take a look at David
McRitchie's:

Getting Started with Macros and User Defined Functions
http://www.mvps.org/dmcritchie/excel/getstarted.htm
 
Back
Top