#1   Report Post  
Posted to microsoft.public.excel.misc
Az
 
Posts: n/a
Default log inverse

i want to take the inverse log of a value. like inverse log (0.69897) in
micro soft Excel.
  #2   Report Post  
Posted to microsoft.public.excel.misc
 
Posts: n/a
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Average Wind Direction rexmorgan Excel Worksheet Functions 3 October 18th 05 04:30 AM
How to calculate an inverse of log base 10 Abdul Basit Excel Worksheet Functions 1 August 6th 05 06:52 AM
formula for inverse tan of a number with answer in degrees raz Excel Discussion (Misc queries) 1 July 4th 05 11:57 PM
Inverse sin John Fitzpatrick Excel Worksheet Functions 3 March 25th 05 07:35 PM
How do I change the inverse colour in an Excel chart? david_hutton.NO_SPAM Charts and Charting in Excel 3 February 21st 05 01:16 PM


All times are GMT +1. The time now is 12:43 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"