The math constand "e" is approximately 2.3. To get the exact value you
use the ln(1).

Ln and log are equivalent functions that give different results because
the base is different. Ln the base is the constand "e", while log base
is usually 10 but can be others bases.


There are 3 functions in excel
LN(Number), LOG(Number,Base), LOG10(Number)

LOG10(Number) = LOG(Number,10)
LN(Number) = LOG(Number,LN(1))


--
joel
------------------------------------------------------------------------
joel's Profile: 229
View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=186592

Excel Live Chat