ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   log inverse (https://www.excelbanter.com/excel-discussion-misc-queries/57488-log-inverse.html)

Az

log inverse
 
i want to take the inverse log of a value. like inverse log (0.69897) in
micro soft Excel.

[email protected]

log inverse
 
"Az" wrote:
i want to take the inverse log of a value.
like inverse log (0.69897)


Depends on how you computed the log in the first place.
If LOG(n) = 0.69897, then 10^0.69897 is n, the inverse
log to the base 10. If LN(n) = 0.69897, then EXP(0.69897)
is n, the inverse log to the base e -- effectively e^0.69897.
In general, if LOG(n,b) = 0.69897, then b^0.69897 is n,
the inverse log to the base b, where "b" is a constant or
a cell reference.


All times are GMT +1. The time now is 08:54 PM.

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