How to use the LOGNORM.INV function in Excel office 365?
Tags: tousethelognorminvfu, excel, excelfunctions
Published: 2021-08-21 10:40:20

---
title: How to use the LOGNORM.INV function in Excel office 365?
published: true
date: 2021-08-17 18:06:39 UTC
tags: ToUseTheLOGNORMINVFu,Excel,ExcelFunctions
canonical_url: https://geekexcel.com/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](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**.

![](https://geekexcel.com/wp-content/uploads/2021/08/Sample-Data.png)<figcaption>Create Sample Data</figcaption>

- 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 )
```

![](https://geekexcel.com/wp-content/uploads/2021/08/Use-the-formula-1.png)<figcaption>Use the formula</figcaption>

- 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](https://geekexcel.com/)** and [**Excel Formulas**](https://geekexcel.com/excel-formula/) **!!**

**Keep Reading:**

- **[How to Create a Normal Distribution Chart (Bell Curve) in Excel?](https://geekexcel.com/how-to-create-a-normal-distribution-chart-bell-curve-in-excel/)**
- **[Excel Formulas to Generate Random Number Weighted Probability!!](https://geekexcel.com/excel-formulas-to-generate-random-number-weighted-probability/)**
- **[Formulas to Count Cells Either X or Y In Excel Office 365!!](https://geekexcel.com/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!!](https://geekexcel.com/excel-formulas-to-sum-the-values-in-the-cells-that-contain-both-x-and-y/)**