How to use the GAMMA.DIST function in Excel Spreadsheet?
Tags: tousethegammadistfun, excel, excelfunctions
Published: 2021-08-23 11:53:14

---
title: How to use the GAMMA.DIST function in Excel Spreadsheet?
published: true
date: 2021-08-17 18:09:06 UTC
tags: ToUseTheGAMMADISTFun,Excel,ExcelFunctions
canonical_url: https://geekexcel.com/how-to-use-the-gamma-dist-function-in-excel-spreadsheet/
---

 **GAMMA.DIST** is an **updated version of the GAMMADIST function** in Excel. It takes the **value** and the **two parameters** named **alpha and beta**. In this tutorial, we will guide you to know how to **use the GAMMA.DIST Function In Excel Spreadsheet.** 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)**

## GAMMA.DIST Function syntax

```
=GAMMA.DIST(x, alpha, beta, cumulative)
```

**Syntax Explanation:**

- **x** : **value** at which you want to **evaluate the distribution**.
- **alpha** : **parameter** to the distribution.
- **beta** : **parameter** to the distribution. If **beta = 1** , **GAMMA.DIST** returns the **standard gamma distribution**.
- **cumulative** : **logical value** that determines the form of the function. If **cumulative is TRUE** , **GAMMA.DIST** returns the **cumulative distribution function** ; if **FALSE** , it returns the **probability density function**.

## Example

- Firstly, you need to **create the sample data** with **value x and the two parameters named alpha and beta.**

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

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

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

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

- After that, you have to find the **probability density distribution**.
- You need to use the following **formula** given below.

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

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

**NOTE:**

- The GAMMA.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**.
  - If x < 0
  - If alpha < =0
  - If beta < = 0
- Now, the **cumulative argument** can be used with **boolean numbers** (0 and 1) or (FALSE or TRUE).
- You can **feed the arguments** to the **function** directly or using the **cell reference,** as explained in the example.

## Conclusion

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

**Continue Reading:**

- **[Insert Sheet in Microsoft Excel 2007?](https://geekexcel.com/insert-sheet-in-microsoft-excel-2007/)**
- **[Excel Formulas to Find the Same Date in Next Year ~ Simple Guide!!](https://geekexcel.com/excel-formulas-to-find-the-same-date-in-next-year/)**
- **[Get the Current Worksheet Name Only in Excel Office 365!!](https://geekexcel.com/get-the-current-worksheet-name-only-in-excel-office-365/)**