Excel like a finance pro.
← The libraryPractice · 2 questions →
Statistical function
PHI
Returns the value of the standard normal density function at x.
Rarely usedDifficulty 1450 · AdvancedUsage rank #380 of 520
When to use it
The standard normal density at z: the height of the bell curve.
The shape of it
- Syntax
=PHI(x)
Worked examples
At the mean
=PHI(0) → 0.39894228
The peak.
One sd
=PHI(1) → 0.241970725
One sd out.
Nearly two sds
=PHI(1.96) → 0.058440944
Nearly two sds out.
Worth knowing
- Same as NORM.S.DIST(z,FALSE).
- Plot it across -3 to 3 for the classic bell curve.
- Not a probability; the area under it is.
Where it goes wrong
- Confusing density with cumulative probability.
- Text input returns #VALUE!.
Related
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.