Common questions about NORM.INV usually involve formula entry, argument setup, and result checking; this section includes 3 FAQs and a 3-term glossary.
FAQ
What should I do if NORM.INV returns an error?
- Check whether the formula starts with
=. - Confirm that parentheses are paired correctly and arguments are separated properly.
- Make sure the number and type of arguments match the function requirements.
How can I view argument hints for NORM.INV?
- Select the target cell and type
=NORM.INV(. - Look at the function hint shown in the formula editing area.
- Follow the hint to continue entering the arguments.
Why does the NORM.INV result look incorrect?
- Check whether referenced cells are stored as numeric values.
- Confirm that probability, mean, and standard deviation are mapped correctly.
- Review references and nested formula logic for mistakes.
Glossary
| Term | Definition |
|---|---|
| NORM.INV | A function that returns the inverse of the normal cumulative distribution for a given probability. |
| Cross-sheet reference | A way to use data from another worksheet inside the current formula. |
| Nested formula | A formula structure that includes another function or expression inside it. |