How to use the LOGNORM.INV function in Excel office 365?

The LOGNORM.INV function is a built-in statistical function that returns the x value for the probability of log-norma l distribution. It takes the 3 arguments. In this tutorial, we are going to see how to Use The LOGNORM.INV Function In Excel Office 365. Let’s get into this article!! Get an official version of ** MS Excel** from the following link: https://www.microsoft.com/en-in/microsoft-365/excel

LOGNORM.INV Function syntax

=LOGNORM.INV(probability, mean, std_dev)

Syntax Explanation:

• probability : probability value for the distribution.
• mean : mean of inverse for log normal distribution.
• std_dev : standard deviation for inverse of log normal distribution.

Example

• Firstly, you need to create the sample data with probability value , mean value and standard deviation value.

Create Sample Data

• Then, you have to calculate the x value for the inverse of log normal distribution function.
• Now, you need to use the following formula given below.

=LOGNORM.INV ( B2, B3, B4 )

Use the formula

• After that, you have to perform the inverse of this function, i.e. you can find the probability value using the x value , mean value and standard deviation value for the log normal distribution using the LOGNORM.DIST function.
• Finally, you need to use the cumulative argument as TRUE to get the x value.

NOTES:

• The LOGNORM.INV Function only works with numbers.
• If any argument other than cumulative is non-numeric , the function returns #VALUE! error.
• The function returns #NUM! Error.
  1. If argument prob < 0 or > 1
  2. If argument mean <= 0
  3. If argument std_dev < 0
• Then, the value in decimal and value in percentage id the same value in Excel and convert the value to percentage , if required.
• Now, you can feed the arguments to the function directly or using the cell reference as explained in the example.

Wind-Up

From this tutorial, you can get to know the simple formulas used for the LOGNORM.INV Function In Excel Office 365. Hope you like this article!! Please share your query below in the comment box. We will assist you. To learn more, check out Geek Excel and Excel Formulas !!

Keep Reading:

• How to Create a Normal Distribution Chart (Bell Curve) in Excel?
• Excel Formulas to Generate Random Number Weighted Probability!!
• Formulas to Count Cells Either X or Y In Excel Office 365!!
• Excel Formulas to Sum the Values in the cells that contain both X and Y!!