GEOMEAN

GEOMEAN(number1 [,number2] [..])

Returns the geometric mean of an array of numbers.

number1The first number.
number2(Optional) The second number.

REMARKS
* The arguments must be either numbers or names, arrays, or references that contain numbers.
* If an array or reference argument contains text, logical values, or empty cells, those values are ignored; however, cells with the value zero are included.
* If any data point = 0, then #NUM! is returned.
* You can have a maximum of 255 arguments.
* For the Microsoft documentation refer to support.microsoft.com
* For the Google documentation refer to support.google.com

 A
1=GEOMEAN(4, 5, 8, 7, 11, 4, 3) = $5.48
2=GEOMEAN(20, 30, 40) = $28.85
3=GEOMEAN(1, 2, 0) = #NUM!


© 2024 Better Solutions Limited. All Rights Reserved. © 2024 Better Solutions Limited Top