Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
log inverse
i want to take the inverse log of a value. like inverse log (0.69897) in
micro soft Excel. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Average Wind Direction | Excel Worksheet Functions | |||
How to calculate an inverse of log base 10 | Excel Worksheet Functions | |||
formula for inverse tan of a number with answer in degrees | Excel Discussion (Misc queries) | |||
Inverse sin | Excel Worksheet Functions | |||
How do I change the inverse colour in an Excel chart? | Charts and Charting in Excel |