View Single Post
  #10   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Harlan Grove[_2_] Harlan Grove[_2_] is offline
external usenet poster
 
Posts: 1,231
Default Geomean function

BobA5835 wrote...
....
Interestingly enough, your formula gave me a closer value to the
target test value than Harlans. My programmer says it may have to
do with the log function in some way.

....

It might. If this were so, you might achieve even higher precision
using a larger base for your logarithms, e.g.,

=128^AVERAGE(LOG(x,128))