CHISQ.INV Function
Returns the inverse of the left-tailed chi-square distribution.
Category
Statistical
Available in
Excel 2010+, Microsoft 365
Returns
A number
Want to practice CHISQ.INV in a real spreadsheet? Open a blank sheet in our Practice Sandbox and try it with live data, with the AI Excel tutor beside you. No Excel needed — just a free account.Try it free in the Sandbox
Overview
The chi-square distribution describes sums of squared differences — it underlies tests of whether counts match what you expected and of whether two categories are related. It's always positive and skewed to the right.
CHISQ.INV returns the value with the given probability below it.
Syntax
=CHISQ.INV(probability, deg_freedom) Explain
Arguments
| Argument | Required? | What it does |
|---|---|---|
| probability | Yes | The left-tail probability, from 0 to 1. |
| deg_freedom | Yes | Degrees of freedom — usually the sample size minus 1 (decimals are truncated); must be at least 1. |
Examples
Example 1 — The 95th percentile
4 degrees of freedom.
B3fx=CHISQ.INV(0.95,B2)
| A | B | |
|---|---|---|
| 1 | Measure | Value |
| 2 | Degrees of freedom | 4 |
| 3 | 95% below | 9.4877 |
| 4 | Same, right tail | 9.4877 |
=CHISQ.INV(0.95,B2) Explain
CHISQ.INV(0.95, …) equals CHISQ.INV.RT(0.05, …) — two ways to find the same 5% cut-off.
Common mistakes
- #NUM! probability is outside 0–1, or deg_freedom is less than 1.
Notes
- Related functions: CHISQ.INV.RT, CHISQ.DIST.

Author
Kyle Stott
Certified Microsoft Excel Expert
Kyle has worked professionally with Microsoft Excel for over a decade and has consulted on and taught Excel best practices to over 400 companies across 30+ countries.