:GEOMEAN function finds the geometric mean-Table skills免费ppt模版下载-道格办公
投稿
  1. JustNewsHome
  2. Table skills
  3. GEOMEAN function finds the geometric mean

GEOMEAN function finds the geometric mean

Author: daogeziyuan • • Table skills • Views 782
  • Picture and text skills
  • Case

Returns the geometric mean of an array or range of positive numbers.

Syntax
GEOMEAN(number1,number2,...)
Number1, number2, ... 1 to 30 parameters that can be used to calculate the average.

You can also use the form of a single array or array reference instead of using commas to separate parameters.


Description
• The argument can be a number, or a name, array, or reference containing numbers.


• If the array or reference parameter contains text , logical values, or blank cells, these values ​​will be ignored; however, cells containing zero values ​​will be counted.


• If any data point is less than 0, Function GEOMEAN returned the error value #NUM!.

Articles are uploaded by users and are for non-commercial browsing only. Posted by: Lomu, please indicate the source: https://www.daogebangong.com/en/articles/detail/GEOMEAN-han-shu-qiu-ji-he-ping-jun-zhi.html

Like (810)
Reward 支付宝扫一扫 支付宝扫一扫
Lomu Le vent se lève Columnist
48 196
single-end

Related Suggestion