average

V

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

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
 
J

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
 
Top