FISHERINV Function
Returns the inverse of the Fisher transformation.
Category
Statistical
Available in
All versions, Microsoft 365
Returns
A number from −1 to 1
Want to practice FISHERINV 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
FISHERINV converts a Fisher z value back into a correlation between −1 and 1: (e^(2z) − 1) ÷ (e^(2z) + 1). If z = FISHER(r), then FISHERINV(z) = r.
It's the last step when you build a confidence interval for a correlation.
Syntax
=FISHERINV(y) Explain
Arguments
| Argument | Required? | What it does |
|---|---|---|
| y | Yes | The Fisher z value to convert back. |
Examples
Example 1 — Turn the interval back into correlations
Fisher z for r = 0.6 with 28 pairs, plus and minus 1.96 standard errors.
B6fx=FISHERINV(B4-1.96*B5)
| A | B | |
|---|---|---|
| 1 | Measure | Value |
| 2 | Correlation (r) | 0.6 |
| 3 | Pairs (n) | 28 |
| 4 | Fisher z | 0.6931 |
| 5 | Std error | 0.2 |
| 6 | Lower 95% | 0.2924 |
| 7 | Upper 95% | 0.7951 |
=FISHERINV(B4-1.96*B5) Explain
The 95% confidence interval for the correlation is 0.29 to 0.80.
Common mistakes
- #VALUE! y isn't a number.
Notes

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.