average

[Vinny]

I am trying to use the LN function inside the average
function and get an error message. Is it possible to nest
these two functions?

 

[J.E. McGimpsey]

What is your formula and what error message do you get.

It's possible to nest:

=AVERAGE(LN(10), LN(20)) ==> 2.649158683

 

[Jerry W. Lewis]

Are any of the numbers <=0, or blank? Try

=AVERAGE(IF(ISNUMBER(E1:E9),LN(E1:E9)))

array entered (Ctrl-Shift-Enter)

Jerry