HARMEAN

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

Returns the harmonic mean of a data set.

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=HARMEAN(4, 4, 4) = 4.000
2=HARMEAN(5, 5, 5) = 5.000
3=HARMEAN(3, 5, 7) = 4.437
4=HARMEAN(4, 5, 6) = 4.865
5=HARMEAN(1, 5, 3, 3) = 2.143
6=HARMEAN(-1, 5, 3, 3) = #NUM!
7=HARMEAN(-1, "some text", 3, 3) = #VALUE!


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