GEOMEAN Function in Apple Numbers: Geometric Average and Growth Examples

• Introduced: Documented in Apple’s Formulas and Functions Help 15.4; the original introduction release is not established.
• Availability: Currently documented for Numbers in that help version; it is not a final supported-version endpoint.
• Scope: Shared iWork function help. Availability in individual clients and older releases is not established by this check.
• Checked: October 14, 2026, against the official GEOMEAN reference. Documentation check; not a new native test.

=GEOMEAN(pos-num, pos-num…)

Apple’s article provides no numerical default value for the optional terms: leaving them out means only the required input remains, rather than filling in zeros. The documented argument type is number value, not collection. Apple’s argument definitions distinguish a number/single-cell expression from a collection or a cell range. Do not assume that =GEOMEAN(B2:B4) is supported merely because another spreadsheet accepts a range. Instead, use the explicit single-cell arguments in this guide until a multi-cell range is tested in the target Numbers release.

There is no separately documented ignore_zeros, weights, or sample argument in Apple’s signature. All examples here use positive plain numbers, avoiding uncertain text/date/duration coercion. Invalid zero/negative values do not satisfy the documented input type; check the installed application’s own error message rather than assuming an exact error code.

1. Create a table named Factors, with Quarter in A1 and Factor in B1. Set column B to a numeric format (not percentage-display strings entered as text).
2. Populate rows 2 through 4 as shown. If the formula will be placed inside this table, choose D2 outside the source cells.
3. Enter the formula with three explicit numeric cell references, exactly in this order; use your locale’s separator if needed.

=GEOMEAN(B2,B3,B4)

Expected result from independent arithmetic: 4. Multiply 1 × 4 × 16 = 64 and take the cube root: 64^(1/3) = 4. No Apple Numbers execution was performed to observe the display.

Compare with the AVERAGE guide using the same cells:

=AVERAGE(B2,B3,B4)

Its independently calculated expected answer is 7 because (1 + 4 + 16) / 3 = 7. Choosing 4 versus 7 is a statistical decision, not a syntax issue. The geometric mean describes a typical multiplicative factor; the arithmetic mean describes the average additive magnitude.

Apple’s six-number example

Apple’s official article includes:

=GEOMEAN(5,7,3,2,6,22)

The product is 27,720. Its sixth root is about 5.50130264578853, which matches the value in the official Apple example to displayed precision. Here the Apple documentation was checked and the computation was independently repeated; this is still not a native Numbers test.

Suppose period-to-period growth factors are 1.05, 1.10, and 0.95 (meaning +5%, +10%, and −5%). Enter them in B2, B3 and B4 instead of the earlier 1, 4, 16 example. All three remain strictly positive, even though one represents a decline.

=GEOMEAN(B2,B3,B4)

Independent expected result: approximately 1.0314191642. The product is 1.09725; the cube root is approximately 1.031419. Thus the equivalent per-period compound increase is about 3.1419%, calculated by (1.0314191642 - 1) × 100.

To express the implied average growth as a percentage, a separate result cell can use:

=(GEOMEAN(B2,B3,B4)-1)*100

Expected numeric result: about 3.1419164168 (percentage points). If you instead format =GEOMEAN(B2,B3,B4)-1 directly as a percentage, the numeric result is about 0.0314191642 and its display would usually be around 3.14%—the formatting is different from multiplying by 100. Verify the cell format before reporting a rate.

Interpretation limitation: A growth factor of exactly 0 corresponds to a complete loss, but it is not a valid GEOMEAN input under Apple’s required >0 rule. A negative factor is likewise excluded. Distinguish a mathematical failure of the function’s domain from a valid but extreme business event.

• Zero or negative input: Apple’s formal requirement is greater than zero for every provided term. Check data errors, and do not silently discard zero outcomes just to force a result.
• Range versus cell references: Apple’s documented pos-num is a number value, which includes a numeric expression or a reference to one numeric cell. Use B2,B3,B4, not an unverified B2:B4 collection argument. If you need a long data column, test the precise Numbers version or work with an audited helper calculation.
• A percentage entered as a text string: Enter numeric 1.05 as a factor, rather than a literal string such as "5% growth". Formatting and parsing depend on locale.
• Wrong growth conversion: A decline of 5% uses 0.95, not −0.05. Zero and negative factors would violate the domain, even though a decline in itself is valid.
• Unexpected result relative to AVERAGE: This is normal. For 1, 4, 16, geometric mean = 4 and arithmetic mean = 7.
• Formula parser error: Confirm the = sign, parentheses, decimal mark and argument separator. Apple’s English reference displays comma-separated arguments; decimal-comma settings use semicolon separators.
• Very large or very small products: Multiplicative calculations may be subject to floating-point range/precision limits. Apple’s short GEOMEAN page does not specify a numeric maximum or exact error token; validate large-scale use in the target app rather than inventing one.
• A single number: The mathematical geometric mean of one strictly positive term is that term. The single-argument behaviour is mathematically derived and not independently executed in Numbers.

All support the concept of a geometric mean of positive numerical data, but this guide certifies Apple’s specific documented argument type, not how competing engines accept full ranges, ignore blanks/Boolean entries, round, or display errors. Some other programs accept a rectangular range for their GEOMEAN function; that is not proof Numbers accepts one. To transfer a workbook, verify the formula with the destination application’s own documentation and test a representative sample. Apple uses Table::Cell references between tables, not Excel’s worksheet exclamation point.

• AVERAGE — arithmetic mean, for additive measurements.
• MEDIAN — middle ranked observation, comparatively resistant to outliers.
• PRODUCT — multiplies inputs, one step in the mathematical definition of a geometric mean.

This page was researched using the Apple Formulas and Functions Help, edition 15.4, accessed 2026-10-12 UTC. This edition does not by itself prove compatibility with every historical Numbers release or every platform. Not executed in Apple Numbers on macOS, iPhone, iPad, or iCloud.com. The displayed answers below are mathematical or documentation-checked expected results, not screenshots or observed output.

The English help examples separate arguments with commas. Apple documents that regions using a comma decimal separator use a semicolon between arguments typed by hand: see Functions overview. Use the Numbers formula editor to construct references. In another table Numbers uses qualifiers such as Data::B2, not Excel-style Sheet1!B2; see Apple’s argument types and table-reference guidance. Regional number displays can differ without changing the underlying mathematics.

The first-supported Numbers version and older-platform differences were not verified for this function. Do not assume a version simply because the current documentation is edition 15.4.

Official claim sources, checked 2026-10-12 UTC:

• Apple GEOMEAN function help, documented as edition 15.4 and accessible Apple function article: function signature, input requirements, and function-specific notes.
• Apple Functions overview: syntax notation and localized argument separators.
• Apple Types of arguments and values: number/collection distinction and Numbers table-qualified references.

Validation: Official documentation and independent arithmetic only; no native Numbers execution or screenshots.