GEOMEAN

Syntax:

GEOMEAN ( argument-list )

Description: Computes the geometric mean of an array or range of positive data.

Mathematical Formula:

Arguments:

Name	Type	Description
argument-list	logical, number, name, array, or reference to number.	The arguments in argument-list designate the values to be averaged. Logical values and text representations of numbers that entered directly into the list of arguments are included. If an array or reference argument contains text, logical values, or empty cells, those values are ignored; however, cells with the value 0 are included.

 

Return Type and Value: number – The geometric mean of an array or range of positive data.

However, if the value of any data point ≤ 0, #NUM! is returned.

[Example:

GEOMEAN(10.5,5.3,2.9) results in 5.444454702
GEOMEAN(10.5,{5.3,2.9},"12") results in 6.633780588

end example]