In this article, we will learn how to calculate delta in Excel. Delta indicates the difference between the 2 numbers. We can easily calculate delta in Excel. Also, there is **DELTA **function available in Excel. We will explain the use of the **DELTA **function in the last section. So, without any delay, letâ€™s start the discussion.

## Calculate Delta in Excel: 2 Ideal Examples

Delta is used for calculating the difference. We will show you 2 examples of calculating Percentage Delta and Delta for Business Model. Letâ€™s follow the steps to learn how to calculate delta in Excel.

### 1. Compute Percent Delta in Excel

To demonstrate the method, we will use a dataset of a companyâ€™sÂ sales information in 2021 and 2022. We want to know the change in sales between 2021 and 2022. We will use **Percent Delta** to show the comparison of the sales for 2021 and 2022.

Letâ€™s see the steps to compute the percent delta in Excel.

**STEPS:**

- Firstly, select the cell where you want to put the result
- We will show our result in the
**%Delta**column. - Therefore, select the
**F5**cell and write the following formula:

`=(E5-D5)/D5`

This formula mainly indicates** (Sales in 2022-Sales in 2021)/ Sales in 2021**.

- Secondly, press
**Enter**, and you can see the result. - After that, drag the formula from
**F5**to**F9**cells with the help of**Auto****Fill**.

- So, the values of
**Delta**are shownÂ in the**%Delta**column. - But, the result is not shown in the percentage format.
- Now, we will change the format of the cells of the
**FÂ**column. - So, select the cells from
**F5**to**F9**.

- Now, go to the
**Home**tab and click on the**Number**of the**Number**group from the ribbon.

- As a result, a drop-down menu will open up, and select
**Percentage**from there. - So, the numbers will be converted into percentage format.

- Finally, we have been able to calculate
**Percent Delta**in Excel.

**Read More: ****How to Calculate Delta Percentage in Excel**

### 2. Calculate Delta for Business Model in Excel

To demonstrate the example, we will use a dataset of a companyâ€™s condition in the Stock Market. We have observed the companyâ€™s Option price and the Underlying stock on the 1st and 31st of October 2022. So, we will calculate the delta to show the comparison of stock market conditions between the 1st and 31st of October.

According to the business model, **Delta** is the ratio of the difference between the Option Price and the Underlying Stock of the company. Letâ€™s see the steps to calculate the delta in Excel.

**STEPS:**

- Firstly, select the
**C8**cell and write the following formula:

`=(C5-C4)/(C7-C6)`

This formula mainly indicates** (Final- Initial Option Value)/(Final-Initial Underlying Value)**.

- Now, pressÂ
**Enter**. - So, you can see the value of
**Delta**in the**C8**cell.

**Read More: ****How to Calculate Option Greek Delta in Excel**

## How to Use DELTA Function in Excel

In this section, we will show the use of **the DELTA function**. To demonstrate the method, we will use a dataset containing age information from a group of children. A renowned theatre group is looking for a 7-year-old child. Using the **DELTA** function, they can easily solve the problem from this dataset.

**Summary**

This function compares **2 **numbers. Then, it returns **1 **if the numbers are equal and returns **0 **if the numbers do not match.

**Syntax**

The syntax of theÂ **DELTAÂ **function is given below:

`=DELTA(number1,[number2])`

**Arguments**

Here, **number1 **is required, and **number2 **is an optional argument. Put the **2 **numbers you want to compare as **number1 **and **number2 **arguments.

Letâ€™s see the steps to know how to use the **DELTA **function in Excel.

**STEPS:**

- First of all, select the
**E8**cell and write the following formula:

`=DELTA(C5,D5)`

- Secondly, press
**Enter**, and you can see the result. - After that, drag the formula from
**E5**to**F9**cells with the help of**AutoFill**.

- Now, you can observe the result.
- Here,
**1**indicates the age of the child is**7**. - And
**0**indicates the age of that child is not**7**.

**Download Practice Workbook**

To practice by yourself, download the following workbook.

## Conclusion

In this article, we have demonstrated how to calculate delta in Excel. There is a practice workbook at the beginning of the article. Go ahead and give it a try.Â Lastly, please use the comment section below to post any questions or make any suggestions you might have.