What is the difference between NORM.DIST() and NORM.INV() in Excel?

I have been studying business statistics, which has a heavy focus on Excel. The normal distribution is used quite extensively in statistics. In Excel, in particular, the normal distribution can be represented in the formula NORM.DIST(). The inverse of the normal distribution is depicted by the formula NORM.INV().

NORM.DIST() and NORM.INV() are opposing forces:-

1. NORM.DIST() uses the x value to get the p value.
2. NORM.INV() uses the p value to get the x value, which is the z value in a standard normal curve.

When is the best time to use each formula?

1. NORM.DIST is used when the analyst wants to find the probability of finding a value less than or equal to x.
2. 1-NORM.DIST() is used when the analyst wants to find a value that is more than or equal to x.
3. NORM.INV() is used when the analyst is given the probability on the left side and want to find what value of x reflects that probability.

An example of how to use find the cumulative probability where the target value is less than x:-