Excel LOGNORM.INV Function

What is LOGNORM.INV function in Excel?


The LOGNORM.INV function is one of the Statistical functions of Excel.

It returns the inverse of the lognormal cumulative distribution function of x where ln(x) is normally distributed with parameters Mean and Standard_dev.

We can find this function in Statistical of insert function Tab.

How to use LOGNORM.INV function in excel

  1. Click on an empty cell (like F5).
 an empty cell in excel

2. Click on the fx icon (or press shift+F3).

fx icon in excel

3. In the insert function tab you will see all functions.

function list in excel

4. Select STATISTICAL category.

5. Select LOGNORM.INV function.

6. Then select ok.

7. In the function arguments Tab you will see LOGNORM.INV function.

8. Probability is a probability associated with the lognormal distribution, a number
between 0 and 1, inclusive.

9. Mean is the mean of ln(x).

10. Standard_dev is the standard deviation of ln(x), a positive number.

11. You will see the results in the formula result section.

Examples of LOGNORM.INV function in Excel

LOGNORM.INV related functions 

LOGNORM.DIST function

Leave a Reply

Your email address will not be published. Required fields are marked *