Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
Is there an antilogarithm calculating function in Excel?
-- AAC |
#2
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
If x=10^y (as in 100 = 10^2)
The we say Log(x) = y (as in log(100) =2) So if I know y I can find x: X = 10^y (if I know y=2 then x = 10^2 = 100) If you are playing with natural logs: x = exp(y) ln(x) = y If I know y then x is found with =EXP(y) best wishes -- Bernard V Liengme www.stfx.ca/people/bliengme remove caps from email "Andre Costin" wrote in message ... Is there an antilogarithm calculating function in Excel? -- AAC |
#3
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
Mon, 7 May 2007 11:52:02 -0700 from Andre Costin
: Is there an antilogarithm calculating function in Excel? Yes. It's 10^A1 for antilogs base 10, and exp(A1) for antilogs base "e" (natural logs). -- Stan Brown, Oak Road Systems, Tompkins County, New York, USA http://OakRoadSystems.com/ |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
LINKEDRANGE function - a complement to the PULL function (for getting values from a closed workbook) | Excel Worksheet Functions | |||
Offset function with nested match function not finding host ss. | Excel Worksheet Functions | |||
Emulate Index/Match combo function w/ VBA custom function | Excel Worksheet Functions | |||
How do I nesting subtotal function within average function in Exc | Excel Worksheet Functions | |||
Nested IF Function, Date Comparing, and NetworkDays Function | Excel Worksheet Functions |