average

  • Thread starter Thread starter Vinny
  • Start date Start date
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?
 
What is your formula and what error message do you get.

It's possible to nest:

=AVERAGE(LN(10), LN(20)) ==> 2.649158683
 
Are any of the numbers <=0, or blank? Try

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

array entered (Ctrl-Shift-Enter)

Jerry
 
Back
Top