Excel like a finance pro.

The functions, VBA, and shortcuts a finance operator actually uses — curated, with CFO examples. Prefer them pre-built? Grab a ready-made model.

← The library

Statistical function

FISHER

Returns the Fisher transformation of a value.

Rarely usedDifficulty 1450 · AdvancedUsage rank #370 of 520

Practice · 2 questions →

When to use it

The Fisher transformation of a correlation coefficient: ATANH(r). It makes correlations approximately normal so you can build confidence intervals and compare them.

The shape of it

Syntax: =FISHER(x)

Worked examples

Moderate correlation
=FISHER(0.5) → 0.549306144
Half of LN(3).
Strong correlation
=FISHER(0.75) → 0.972955075
Stronger correlations stretch further.
Zero
=FISHER(0) → 0
No correlation maps to 0.

Worth knowing

Confidence interval for r: transform, add ± 1.96/SQRT(n-3), then FISHERINV both ends.
Compare two correlations by comparing their transformed values.
Input must be strictly between -1 and 1.

Where it goes wrong

#NUM! at exactly -1 or 1 or beyond.
Rarely needed outside formal statistics.

AVERAGE COUNT COUNTA COUNTIF COUNTIFS MAX

Learn the moves here — or let Wauvel run them on your numbers.

Meet your AI CFO →

One CFO-grade Excel tip a week

A short, practical email for finance operators — functions, shortcuts, and the moves that save an afternoon. Free, unsubscribe anytime.