How to use the LOGNORM.DIST function in Excel office 365?
Tags: tousethelognormdistf, excel, excelfunctions
Published: 2021-08-23 06:16:29

---
title: How to use the LOGNORM.DIST function in Excel office 365?
published: true
date: 2021-08-17 18:06:49 UTC
tags: ToUseTheLOGNORMDISTF,Excel,ExcelFunctions
canonical_url: https://geekexcel.com/how-to-use-the-lognorm-dist-function-in-excel-office-365/
---

The **LOGNORM.DIST** function is a **built-in statistical function** that returns the **probability for the log-normal** distribution. It takes the **3 arguments** with the type of distribution function (cdf or pdf). The **log-normal distribution** is a **continuous probability distribution** of a random variable whose logarithm is normally distributed. A random variable that is log-normally distributed takes only positive real values. It is a convenient and useful model for measurements in exact and engineering sciences as well as medicine, economics, and other fields.

In this tutorial, we are going to see how to **use the LOGNORM.DIST 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.DIST Function syntax

```
=LOGNORM.DIST(x, mean, std_dev, cumulative)
```

**Syntax Explanation:**

- **x** : **value** at which distribution is evaluated.
- **mean** : **mean of log normal** distribution.
- **std\_dev** : **standard deviation of log normal** distribution.
- **cumulative** : **logical value** that determines the form of the function. If **cumulative is TRUE** , **LOGNORM.DIST** returns the **cumulative distribution function** ; if **FALSE** , it returns the **probability density function**.

## Example

- Firstly, you need to **create the sample data** with **x value** , **mean value** and **standard deviation value**.

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

- Then, you have to calculate the **cumulative for the log normal distribution** function.
- Now, you need to use the following **formula** given below.

```
=LOGNORM.DIST ( B2, B3, B4, FALSE)
```

![](https://geekexcel.com/wp-content/uploads/2021/08/cumulative-distribution-1024x176.png)<figcaption>Cumulative distribution</figcaption>

- After that, you can find out the **probability value for the log normal distribution** function for the **value at least 5** following the **same parameters** with the formula shown below.

```
=LOGNORM.DIST ( B2, B3, B4, TRUE)
```

![](https://geekexcel.com/wp-content/uploads/2021/08/probability-mass-distribution-1-1024x169.png)<figcaption>probability mass distribution</figcaption>

- After that, you have to perform the **inverse function** of the log normal distribution.
- Finally, you need to find the **x value** using the **probability value, mean value and standard deviation** using the **LOGNORM.INV function** in Excel.

**NOTES:**

- The LOGNORM.DIST 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 x < 0

  1. If argument mean <= 0
  2. If argument std\_dev < 0
- Then, the **argument x** event is **truncated to integers if not**.
- Now, the **cumulative argument** can be used with **boolean numbers** (0 and 1) or (FALSE or TRUE).
- After that, the **value in decimal** and **value in percentage id** the same value in Excel and **convert the value to percentage** , if required.
- Finally, you can **feed the arguments** to the **function** directly or using the **cell reference,** as explained in the example.

## Closure

From this article, you can get to know the **formulas for how to use the LOGNORM.DIST Function In Excel Office 365**. Hope that this article is useful to you. Kindly, drop your feedback in the below sections. Thank you so much for Visiting Our Site!! Continue learning on **[Geek Excel](https://geekexcel.com/)!! **Read more on [**Excel Formulas**](https://geekexcel.com/excel-formula/) **!!**

**Read Also:**

- **[Excel Formulas to Calculate the Cumulative Loan Interest ~ Easily!!](https://geekexcel.com/excel-formulas-to-calculate-the-cumulative-loan-interest-easily/)**
- **[Excel Formulas to Calculate the Cumulative Loan Principal Payments!!](https://geekexcel.com/excel-formulas-to-calculate-the-cumulative-loan-principal-payments/)**
- **[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/)**