MrExcel
mrexcel.com › forums › question forums › excel questions
Excel inverse log function? | MrExcel Message Board
May 13, 2002 - Hi Jeff, Use =EXP(exponent) to take the inverse of the natural logarithm. Use 10^(exponent) or =POWER(10,exponent) to take the inverse base10 logarithm/ HTH, Jay ... Thanks, Jay. It works great.
MyExcelOnline
myexcelonline.com › home › the ultimate antilogs guide – inverse of log in excel
The Ultimate Antilogs Guide - Inverse of Log in Excel | MyExcelOnline
November 7, 2024 - This error will appear if the input value is negative. To resolve this, make sure that the cells do not contain any negative values. An antilog is the inverse function of a logarithm.
Videos
01:02
How to Use the Inverse Log Function in Excel - YouTube
Log 10, Inverse Anti log 10 in Excel #Shorts - YouTube
Log 10 Transformation Inverse Anti log Log 10 in Excel - YouTube
01:22
How to reverse log base 10 in Excel - YouTube
Log10, Square Root, Cube Root, anti log, inverse SQRT and Cube ...
Excel Forum
excelforum.com › excel-formulas-and-functions › 431991-how-to-calculate-an-inverse-of-log-base-10-a.html
How to calculate an inverse of log base 10 [SOLVED]
June 9, 2005 - Abdul Basit - In general, if y = log10(x), then x = 10^y. So, if you have =LOG10(4) in cell A1, showing approximately 0.60206, then enter =10^A1 in some other cell, which will show 4. - Mike www.mikemiddleton.com
Zx
ftp.zx.net.nz › pub › archive › ftp.microsoft.com › MISC › KB › en-us › 214 › 116.HTM
XL: Formulas to Find the Log and Inverse Log of a Number (214116)
Microsoft Excel has built-in functions to calculate the logarithm of a number with a specified base, the logarithm with base 10, and the natural logarithm. To calculate the inverse log of a number in the first two cases, raise the base to the power of...
GeeksforGeeks
geeksforgeeks.org › excel › how-to-find-the-antilog-of-values-in-excel
How to Find the Antilog of Values in Excel? - GeeksforGeeks
July 23, 2025 - In Excel, the function used to calculate the power of the constant e is EXP. So, we need the EXP function in order to calculate the antilog of natural logarithmic values. The EXP function is basically the inverse of the LN function in Excel.
ExcelDemy
exceldemy.com › home › excel formulas › how to do inverse log in excel (3 methods)
How to Do Inverse Log in Excel (3 Methods) - ExcelDemy
July 29, 2024 - We’ll use the POWER function for this purpose. The POWER function calculates a result when we provide a base and an exponent as function arguments. Follow the steps below to compute the inverse of a Common Log in Excel:
Microsoft Support
support.microsoft.com › en-us › office › lognorm-inv-function-fe79751a-f1f2-4af8-a0a1-e151b2d4f600
LOGNORM.INV function - Microsoft Support
This article describes the formula syntax and usage of the LOGNORM.INV function in Microsoft Excel. Returns the inverse of the lognormal cumulative distribution function of x, where ln(x) is normally distributed with parameters Mean and Standard_dev.
Statology
statology.org › home › how to find the antilog of values in excel
How to Find the Antilog of Values in Excel
May 24, 2021 - The antilog of a number is the inverse of the log of a number. So, if you calculate the log of a number you can then use the antilog to get back the original number. For example, suppose we start with the number 7. If we take the log (base 10) ...
Corporate Finance Institute
corporatefinanceinstitute.com › home › resources › lognorm.inv function
Inverse Lognormal Distribution Excel - Formula, Examples, How to Use
December 15, 2023 - Calculate the inverse of the lognormal cumulative lognormal distribution function at a given value of x ... The LOGNORM.INV Function[1] is categorized under Excel Statistical functions.
Microsoft Support
support.microsoft.com › en-us › office › exp-function-c578f034-2c45-4c37-bc8c-329660a63abe
EXP function - Microsoft Support
The constant e equals 2.71828182845904, the base of the natural logarithm. ... Number Required. The exponent applied to the base e. To calculate powers of other bases, use the exponentiation operator (^). EXP is the inverse of LN, the natural logarithm of number.
Reddit
reddit.com › r/askmath › how does the inverse function of log work?
r/askmath on Reddit: How does the inverse function of log work?
July 4, 2021 -
Hello everyone !
I have recently picked up the "No Bullshit Guide to Mathematics" and something has been bothering me : the log inverse function.
It says that log a(x) is equivalent to ax, or at least I understood it that way.
So I tried to apply it in an exercise :
Solve x in the following equation log 5(x) = 2
My thinking got me to a dead end where I ended up with 5x = 25. Apparently, I was meant to put the whole log expression in the ax part, and obtain 5log 5(x) = 5² then simplify to x = 25. But why is that? I really can't wrap my head around why that happens. To me the a is 5, and the x is simply x here, which would result in 5x.
Thanks in advance, any help is welcome :)
Top answer 1 of 2
1
You got the inverse function wrong: when you say loga(x)=b you are equivalently saying ab =x, not ax =b For example, log10(100)=2 because 102 =100. Whenever you are trying to find out the value of loga(x) you are basically asking: “which exponent should a be raised to to obtain x?” In your example log5(x)=2 means 52 =x therefore x=25 What your book gives you is an easy way of solving the general case: if two quantities are the same then raising the same base to one side or the other of your equation should lead to another equality: x = y <=> ax = ay By choosing a in a clever way you can simplify the logarithm which is what your book suggests, leading to the same result. This approach seems a bit more complex in the simple examples above but it is a very practical mechanical way of always finding out the correct answer (asking “which exponent should I raise 1.2 to to get 17.4?” Is not as easy compared to just applying the suggested method) and will make inequalities easier to work with too whenever you’ll get there EDIT: formatting is trash but I’m on phone, apologies. If unclear lmk and I will try to explain once more :)
2 of 2
1
These are all equivalent: Power = BaseExponent Base = Exponent√Power Exponent = log_Base (Power) For your example: log_5 (x) = 2 Exponent = log_Base (Power) exponent is 2, base is 5, power is x Base = Exponent√Power 5 = 2√x this is correct but we can do better Power = BaseExponent x = 52
ExcelDemy
exceldemy.com › home › excel formulas › how to calculate a logarithm in excel (6 methods)
How to Calculate a Logarithm in Excel (6 Methods) - ExcelDemy
July 16, 2024 - Read More: How to Do Inverse Log in Excel · We can utilize Visual Basic for Applications (VBA) to craft shortcuts for computing logarithms within Excel. Let’s compute the logarithm of 125 with a base value of 5. Follow the steps outlined below: Creating the VBA Code ·
Pct
byoc.pct.edu › inverse-of-log-on-calculator
5 Quick Ways to Find Inverse Log on Calculator
The biggest gaming event on campus! Free to everyone. Tournaments, casual games, and door prizes. Bring your own games or play ours. We have new consoles, old consoles, board games, card games, and more! Food is available at the event, purchasable with flex dollars · These rules are in place ...
Reddit
reddit.com › r › excel › comments › 49r4zj › inverse_logarithmic_y_axis
r/excel - "Inverse Logarithmic" Y Axis?
Where to LearnExcel EssentialsVBA EssentialsPowerQuery/r/excel Wiki · Filter by Flair · UnsolvedDiscussionPro TipShow and TellChallengeAbout Clippy(Points) 1 · Posted by7 years ago · unsolved · I can't even really figure out how to search for my question so I thought I would ask here. I am wanting to chart percentages on a scatter plot, but most data points are clustered between 90-100, with a few outliers at lower percentages. I would like to set my Y axis to almost an "inverse logarithmic" scale so my bottom is still at 0, but the midpoint is at, say, 90, next is 95, then 97, 98, etc.
LinkedIn
linkedin.com › posts › johnmichaloudis_excel-msexcel-microsoftexcel-activity-7262570025738248192-uIja
John Michaloudis (Microsoft Excel MVP)'s Post
We cannot provide a description for this page right now
Huntertur
helparchive.huntertur.net › document › 97903
Q79945 - XL: Formulas to Find the Log and Inverse Log of a Number
Formula Operation Example Result ------------------------------------------------------ =LOG(n,b) Log base b of n =LOG(8,2) 3 =(b)^(x) Inverse log of the =2^3 8 number x, base b =LOG10(n) Log base 10 of n =LOG10(100) 2 =10^(x) Inverse log of the =10^2 100 number x, base 10 =LN(n) Natural log of n =LN(100) 4.6051702 =EXP(x) Inverse natural =EXP(4.6051702) 100 log of the number x NOTE: In the above table, "n" is a variable that is either a value or the address of a cell containing a value, "b" (in the first function) is the base with which the logarithm is calculated, and "x" is a variable representing the result of the log function being used. NOTE: Unless a different value or cell address is specified, the default value for the base is 10. "Microsoft Excel Function Reference," version 3.0, pages 72, 143-144
Microsoft Learn
learn.microsoft.com › en-us › office › vba › language › reference › user-interface-help › log-function
Log function (Visual Basic for Applications) | Microsoft Learn
This example uses the Log function to return the natural logarithm of a number. Dim MyAngle, MyLog ' Define angle in radians. MyAngle = 1.3 ' Calculate inverse hyperbolic sine.
Reddit
reddit.com › r/excel › does excel 365 have a function for calculating the inverse error function from two values?
Does excel 365 have a function for calculating the inverse ...
February 1, 2022 -
The math is beyond my level but I need to calculate the inverse error function using the lower value of 0.07 and the higher value of 0.9. An online calculator returns that value of 1.004. I can't seem to find the function on my version of excel. Is there an add on I can install or am I missing it?
Inverse error function Calculator - High accuracy calculation (casio.com)
If someone can explain what the hell it means, in a way that I can understand, that would be great too.
Spreadsheet Planet
spreadsheetplanet.com › home › how to calculate antilog in excel (formula)
How to Calculate Antilog in Excel (Easy Formula)
December 2, 2024 - In other words, it is the inverse of the LOG10 function (or Log function if using a base other than 10). So, to find the antilog of a number, all you need to do is raise it to the power of 10. For example, the base-10 log of the number 5 is 0.69897.
Inside The Web
insidetheweb.com › home › office › excel › here’s how to reverse log base 10 in excel
Here's How to Reverse Log Base 10 in Excel
December 5, 2023 - However, you will need to reverse the logarithm to get the original data when dealing with scientific calculations. For instance, if you have y=log10(1000), the inverse would be x=10y=1000.