Zoho Sheet GAMMA Function: Positive Inputs and Factorial Offsets

Zoho’s official GAMMA entry was retrieved on October 15, 2026. It documents the current rolling web service, not an original introduction release or last functioning version; both historical endpoints remain unknown. Mobile/offline parity is unverified. The additional calculations below are independent mathematical expectations, not native Zoho Sheet output.

GAMMA(x)

There is one required numeric argument. Zoho explicitly documents #NUM! when x≤0. Stay within positive x. The mathematical gamma function can be extended to certain negative nonintegers, and some spreadsheet products accept those arguments, but that is not Zoho’s documented contract. Do not copy a negative-input Excel example into this guide’s supported domain.

GAMMA is also distinct from GAMMADIST, which evaluates a gamma probability distribution using additional parameters, and GAMMALN, which returns the natural logarithm of gamma. These are different questions, not alternate spellings.

The vendor gives =GAMMA(12) as 39,916,800. This is 11!, so it independently confirms the integer offset. Its other explicit literal, =GAMMA(23.35), is shown as approximately 3.351344E21. A cell-reference example is also listed, but its referenced input is not specified in the extracted text; this guide does not invent that missing input.

Keep the exact input 23.35 separate from the rounded scientific-notation result. The result’s displayed digits are not a claim that Zoho guarantees the same relative precision for every large input.

Create GammaValues with x, Gamma, Recurrence and Ratio in A1:D1. Enter the numeric x values below in A2:A9. Fill B2 =GAMMA(A2), C2 =GAMMA(A2+1) and D2 =C2/B2 through row 9.

Mathematically, C equals A×B and D equals A, because Γ(x+1)=xΓ(x). For x=2.5, B is approximately 1.329340388, C is 3.323350970, and D is 2.5. This checks two related calls without confusing gamma with the factorial of a fractional number.

In a copy change A6 from 2.5 to 3.5. B6 becomes approximately 3.323350970, C6 becomes 11.631728397, and D6 becomes 3.5. Other rows stay unchanged. Allow floating-point tolerance rather than demanding exact binary equality in the ratio.

For integer n=5, the factorial is =GAMMA(5+1), expected 120. The +1 is essential. A direct GAMMA(5) is 24.

For the ratio Γ(8)/Γ(5), enter =GAMMA(8)/GAMMA(5). The result is 210. Independently, the recurrence cancels the common factors and leaves 5×6×7 = 210. This cancellation explains the ratio’s scale and may avoid creating unnecessarily large intermediate values in a hand-derived model.

For larger arguments, direct gamma values grow quickly. GAMMALN supports a logarithmic representation. For the small control, =EXP(GAMMALN(8)-GAMMALN(5)) also has mathematical expected result 210. Logarithms can reduce intermediate magnitude, but they do not establish a universal accuracy guarantee or prevent the final EXP from overflowing.

For positive shape parameters 2 and 3, the mathematical beta integral is Γ(2)Γ(3)/Γ(5)=1/12. Its reciprocal is 12. A supplied model proportional to x×(1−x)² on 0≤x≤1 therefore has normalized form 12x(1−x)².

Enter 0.25 in F2 and =GAMMA(5)/(GAMMA(2)*GAMMA(3))*F2*(1-F2)^2 in G2. The expected density height is 1.6875. A density height can exceed one; it is not the probability of a point. This example illustrates normalization of an explicitly stated mathematical model, not evidence that observations follow that distribution.

The documented nonpositive-input rule includes zero and every negative value. Do not suppress those errors to make an unsupported input appear to work. The shared glossary also lists invalid names, references and types; blank-cell coercion, numeric text, array behavior and exact overflow limits are not established here.

If a result is off by a factorial factor, check the input offset. If a large result is rounded, inspect the full cell value and number format before concluding that the formula failed. Avoid subtracting nearly equal huge gamma values when the mathematics can be rearranged into a better-scaled expression.

The examples were independently calculated at high precision. That supports the stated ordinary mathematical expectations, not native precision, platform parity or undocumented negative-domain behavior.