在Excel中查找百分比变化需要计算两个数字之间的差异,将该差异除以连续数字并将小数值更改为百分比。如果有一系列数字,您可以将公式拉到整个数字范围内。
你如何计算Excel中的百分比增加或减少(Excel)
让我们了解百分比变化的基础知识。百分比变化是(新值-旧值)/旧值。因此,百分比变化公式的语法变为:
=(<cell with new value>-<cell with old value>)/<cell with old value>
在哪里,
- <具有新值的单元格> 是计算中的第二个单元格
- <具有旧值的单元格> 是计算中的第一个单元格
此公式可适用于Excel工作表中的任意两个随机单元格,除非您需要使用“(Excel)填充(Fill)”选项在一系列单元格中查找结果。在这种情况下,讨论中的单元格需要跨两个不同的列放置在同一行中。
例如。从第 3 行开始,我们在 B 列和 C 列中有一系列值。因此,第一个比较值将在单元格 B3 和 C3 中。
计算从单元格 B3 到单元格 C3 的百分比差异的公式将变为:
=(C3-B3)/B3
其中,B3 是 B 列单元格范围中的第一个单元格,我们从该单元格开始计算百分比变化。
C3 是跨列 C 的单元格范围中的第一个单元格,直到我们计算百分比变化。
假设我们需要 E 列中具有百分比差异的单元格范围。然后将用于在此示例中查找百分比差异的公式放在单元格 E3 中。
但是,这将给出整数或十进制格式的值。要获得百分比格式的值,请单击功能区(Ribbon)数字(Number)部分的百分比(Percentage)按钮。
同样,结果仅适用于一个单元格。要将结果从列中拉出,请使用Fill函数。让我们假设结果要计算到第 16 行,同时计算到单元格E16,那么您将不得不再次单击单元格 C3。
选择后,单击单元格右下角的小点以突出显示“填充(Fill)”选项。现在不释放鼠标单击,将选择下拉到E16。
希望能帮助到你!
How do you calculate Percentage increase or decrease in Excel?
Finding percentage сhange in Excel requіrеs сalculаtіng the difference between two numbers, dividing that differenсe by the successive number and changing the decimal value to a percentage. In case of a range of numberѕ, you сould pull the formula down across the range of numbers.
How do you calculate percentage increase or decrease in Excel
Let us understand the basics of the percentage change. The percentage change is (new value-old value)/old value. Thus, the syntax for the percentage change formula becomes:
=(<cell with new value>-<cell with old value>)/<cell with old value>
Where,
- <cell with new value> is the second cell in the calculation
- <cell with old value> is the first cell in the calculation
This formula could be applicable for any two random cells across the Excel sheet, except when you need to find the results across a range of cells using the Fill option. In that case, the cells in discussion need to be placed in the same row across two different columns.
Eg. We have a range of values in columns B and C starting from row 3. Thus the first comparison values would be in cells B3 and C3.
The formula to calculate the percentage difference from cell B3 to cell C3 would become:
=(C3-B3)/B3
Where, B3 is the first cell in the range of cells across column B from which we start calculating the percentage change.
C3 is the first cell in the range of cells across column C till which we calculate the percentage change.
Let us say we need the range of cells with the percentage difference in column E. Then place the formula for finding the percentage difference in this example in cell E3.
However, this would give the value in integer or decimal format. To attain the value in percentage format, please click on the Percentage button in the Number section of the Ribbon.
Again, the results are for one cell only. To pull the results down across the column, use the Fill function. Let us suppose the results are to be counted till row 16 and simultaneously till cell E16, then you would have to click on cell C3 once again.
Once it is selected, click on the small dot at the right-bottom corner of the cell to highlight the Fill option. Now without releasing the mouse-click, pull the selection down to E16.
Hope it helps!