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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Nesting SUBTOTAL with SUMPRODUCT? 0
Averaging to-date lists??? 1
Average of Subtotals in Pivot Table 0
CONCATENATE & LOOKUP Functions 0
Insert Column, Keep Average range 1
No including ZERO'S when using Average fucntion 6
AVERAGE 7
Using =address to provide address location for =average 2

Back
Top