当您想知道两个数字之间的百分比差异时，通常会计算百分比差异。Microsoft Office Excel是帮助您入门的绝佳工具。在这篇文章中，我们看到了在 Excel中查找两个数字之间百分比差异的方法。^{(find the percentage difference)}

计算^(Calculate)Excel中两个数字之间的百分比差异

百分比变化或百分比差异可以应用于您随时间测量的任何数量。它是一个简单的数学概念，表示随时间变化的程度。使用简单的公式可以帮助您找到两个数字之间的百分比差异。就是这样！

1]输入值^{(1] Enter values)}

百分比值的变化可以定义为原始值与新值之间的差异除以原始值。

例如，A 公司2018 年的销售额 $485,000$598,634。那么，这两年的百分比变化是多少？

启动Office Excel。制作两张^{(Make two)}表“ 2018 Sales ”和“ 2019 Sales ”（突出显示^(Highlight)“Bold”中的字母，以免误认为是百分比计算）。

2]使用公式^{(2] Use the formula)}

接下来，单击单元格 B3 以将百分比^(Percentage)格式应用于单元格。

现在，转到“主页^(Home)”选项卡并在“数字格式”下选择百分比^(Percentage)按钮，如上图所示。

注意：如果您使用的是 Excel 的 Web 版本，^(Excel)即Excel网页版，请单击主页^(Home)>数字格式^{(Number Format)}>百分比^(Percentage)。

之后，单击单元格B3内部，将第二年的销售额 ($598,634.00) 除以第一年 ($485,000.00)，然后减去 1。在单元格C3中使用以下公式。=（B2/A2）-1。

完成后，将立即计算并显示两年之间的百分比变化。如您所见，两年之间的百分比变化为 23%。

注意( ^(Notice)B2/A2 )周围的括号。Excel首先计算括号中的内容，然后减去 1。

我希望你觉得这个技巧很有用。
^{(I hope you find this tip useful.)}

How to calculate percentage difference between two numbers in Excel

The percentage difference is usually calculatеd when you want to know the difference in percentage between two numbers. Microsoft Office Excel is a great tool to help yоu get started. In this post, wе see the method to find the percentage difference between 2 numbers in Excel.

Calculate percentage difference between two numbers in Excel

Percentage change or percentage difference can be applied to any quantity that you measure over time. It is a simple mathematical concept that represents the degree of change over time. The use of simple formulas can help you find the percentage difference between 2 numbers. Here’s how!

1] Enter values

The change in percentage value can be defined as the difference between an original and a new value, divided by the original value.

For example, A company sold $485,000 in 2018 and $598,634 in 2019. Then, what’s the percent change in the two years?

Launch Office Excel. Make two tables ‘2018 Sales’ and ‘2019 Sales’ (Highlight the letters in ‘Bold’, so you don’t mistake them for percentage calculation).

2] Use the formula

Next, click on the cell B3 to apply the Percentage format to the cell.

Now, go to the ‘Home’ tab and under ‘Number Format’ select the Percentage button, as shown in the image above.

Note: If you are using the web version of the Excel, i.e., Excel for the web, click Home > Number Format > Percentage.

After that, click inside cell B3, divide the second year’s sales ($598,634.00) by the first year ($485,000.00), and then subtract 1. Use the following formula in cell C3. =(B2/A2)-1.

Once done, the change in percentage between the two years will be calculated and displayed instantly. As you can see, the change in percentage between two years was found to be 23%.

Notice the parentheses around (B2/A2). Excel calculates what’s in parentheses first, and then subtracts the 1.

I hope you find this tip useful.

Related posts

• 如何在Excel中使用Percentile.Exc function

• 如何使用NETWORKDAYS function在Excel

• 如何计算在Excel的Yes or No entries数

• Excel，Word or PowerPoint上次无法启动

• 如何在Excel中使用Automatic Data Type feature

• 如何在Excel中使用Duration Financial Function

• 如何在Microsoft Excel中添加或汇总Time

• 如何在Excel中使用INT and LCM Functions

• 如何在Excel中使用DISC function

• 如何在Excel中创建Organization Chart

• 如何在Microsoft Excel worksheet中添加Trendline

• 如何在Excel中使用DCOUNT and DCOUNTA Function

• 运行时error 1004，不能在Excel运行Macro

• How以使用Excel的Mode function

• 如何在Windows 11/10中创建Radar Chart

• 如何在Excel中使用CHOOSE function

• 如何启动Word，Excel，PowerPoint，Outlook在Safe Mode

• 如何在Excel中使用Find and FindB functions

• 如何在一页上打印Excel or Google Sheets中所选单元格

• 如何在Excel中添加Country or Area Code至Phone Number List