StatisticsLevel: ExpertAvailable in: Excel 2010+
In this article
- Syntax
- Examples
- Example 1
- Example 2
- Related functions
NORM.INV is the reverse of NORM.DIST: give it a probability and it returns the value. Great for safety stock, and for simulations with RAND().
Syntax
=NORM.INV(probability, mean, standard_dev)
| Argument |
What it means |
probability |
Between 0 and 1. |
Examples
Example 1
=NORM.INV(0.95, 200, 30)
Stock that covers demand on 95% of days (about 249).
Example 2
=NORM.INV(RAND(), 200, 30)
One random simulated day of demand.
NORM.DIST · RAND
📚 Part of the free Excel course: Beginner → Expert · Try it in the Formula Lab or ask the AI Helper.
✨ Ask AI about this articleStuck on a step? Ask a question and the AI answers using this article.
Free · AI can be wrong