# How to Calculate Delta in Excel – 2 Examples

### Example 1 – Computing Percent Delta in Excel

The sample dataset contains sales information. To compare sales in 2021 and 2022, you can calculate delta percentages in Excel.

STEPS:

• Select a cell to display the result, %Delta column, here.
• Select F5 and enter the following formula:
`=(E5-D5)/D5`

This formula isÂ  (Sales in 2022-Sales in 2021)/ Sales in 2021.

• Press Enter to see the result.
• Use the AutoFill to drag the formula from F5 to F9.

• Delta values are shownÂ in the %Delta column, but not in percentage format.
• To change the format, select F5:F9.

• Go to the Home tab and choose the Number group on the ribbon.
• Click Number.

• In the drop-down menu, select Percentage.
• Numbers will be converted into percentage.

• Percent Delta is calculated.

### Example 2 – Calculating Delta for Business Models in Excel

This dataset showcases the performance of a company in the Stock Market.

STEPS:

• Select C8 and enter the following formula:
`=(C5-C4)/(C7-C6)`

The formula indicates (Final- Initial Option Value)/(Final-Initial Underlying Value).

• Press Enter.
• The Delta value is displayed in C8.

## How to Use the DELTA Function in Excel

The sample dataset contains information about the age of a group of children. A renowned theater group is looking for a 7-year-old child. Using the DELTA function,Â  can solve the problem.

• Summary

This function compares 2 numbers. 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:

`=DELTA(number1,[number2])`
• Arguments

Here, number1 is a required argument, and number2 is optional. Enter the 2 numbers you want to compare as arguments number1 and number2.

STEPS:

• Select E8 and enter the following formula:
`=DELTA(C5,D5)`

• Press Enter to see the result.
• Drag the formula from E5 to F9 using the AutoFill.

• This is the result.
• 1 indicates the age of the child is 7, whereas 0 indicates the age of that child is not 7.

## Related Articles

<< Go Back to Excel DELTA Function | Excel Functions | Learn Excel

Get FREE Advanced Excel Exercises with Solutions!
Sudipta Chandra Sarker

Sudipta Chandra Sarker, BSc, Electrical and Electronic Engineering, Bangladesh University of Engineering and Technology, Bangladesh, has worked on the ExcelDemy project for over a year. For ExcelDemy, he has authored 42 articles and reviewed over ten articles. He is employed as a junior software developer at the moment. He aims to create various useful Microsoft Office Add-ins, extending the functionality of Office programs. His interests span Microsoft Office Suites, Data Science, VBA, VB.NET, ASP.NET, C#, Excel, and Desktop... Read Full Bio

We will be happy to hear your thoughts

Advanced Excel Exercises with Solutions PDF