ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   How to calculate an inverse of log base 10 (https://www.excelbanter.com/excel-worksheet-functions/39080-how-calculate-inverse-log-base-10-a.html)

Abdul Basit

How to calculate an inverse of log base 10
 
I use the formulat Log10 (4) to calculate the log base 10 of 4. How can I
compute the inverse of log 10.

Mike Middleton

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

"Abdul Basit" wrote in message
...
I use the formulat Log10 (4) to calculate the log base 10 of 4. How can I
compute the inverse of log 10.





All times are GMT +1. The time now is 07:21 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com