I have an Excel column (total per x) and row (cumulative values of y) and I want to calculate the %.
我有一个Excel列(每x总共)和行(y的累积值)，我想计算%。
In the following example I'm trying to calculate for example : BQ18/BQ89, then BP19/BP89, BO20/B089 etc. My table is shown on the picture.
在下面的示例中，我尝试计算例如:BQ18/BQ89，然后是BP19/BP89, BO20/B089等等。
1 个解决方案
#1
1
You generally do not explicitly calculate percentage in Excel. You simply divide the 2 numbers and format the cell to show % instead of plain number. Try right-clicking the cell and choosing % format.
在Excel中通常不显式地计算百分比。您只需将两个数字分隔开，并格式化单元格以显示%而不是普通数字。尝试右键单击单元格并选择%格式。
It seems I also have to mention the basic Excel mechanism of prefixing the reference with $. Try to enter this formula somewhere on your sheet:
我似乎还要提到基本的Excel机制，即在引用前面加上$。试着把这个公式写在你的纸上:
=BC6/$BQ$89
Then go with the mouse cursor to the bottom right corner of the formula cell, grab it and drag it down without releasing the button. You will clone the formula. When you clone the formula in this way, BC6 becomes BC7, BC8, BC9 etc., while $BQ$89 stays unchanged because it is prefixed with $ sign. After you release the mouse button, grab it again and drag it to the right so as to create a whole table of ratios. Then format this table to show %. For further reference, see eg here.
然后将鼠标光标移到公式单元格的右下角，抓住它并向下拖动，而不释放按钮。你将克隆这个公式。当你以这种方式克隆公式时，BC6变成了BC7、BC8、BC9等等，而$BQ$89保持不变，因为它的前缀是$ sign。释放鼠标按钮后，再次抓取它并将其拖到右边，以创建一个完整的比率表。然后格式化此表以显示%。如需进一步参考，请参阅此处。
#1
1
You generally do not explicitly calculate percentage in Excel. You simply divide the 2 numbers and format the cell to show % instead of plain number. Try right-clicking the cell and choosing % format.
在Excel中通常不显式地计算百分比。您只需将两个数字分隔开，并格式化单元格以显示%而不是普通数字。尝试右键单击单元格并选择%格式。
It seems I also have to mention the basic Excel mechanism of prefixing the reference with $. Try to enter this formula somewhere on your sheet:
我似乎还要提到基本的Excel机制，即在引用前面加上$。试着把这个公式写在你的纸上:
=BC6/$BQ$89
Then go with the mouse cursor to the bottom right corner of the formula cell, grab it and drag it down without releasing the button. You will clone the formula. When you clone the formula in this way, BC6 becomes BC7, BC8, BC9 etc., while $BQ$89 stays unchanged because it is prefixed with $ sign. After you release the mouse button, grab it again and drag it to the right so as to create a whole table of ratios. Then format this table to show %. For further reference, see eg here.
然后将鼠标光标移到公式单元格的右下角，抓住它并向下拖动，而不释放按钮。你将克隆这个公式。当你以这种方式克隆公式时，BC6变成了BC7、BC8、BC9等等，而$BQ$89保持不变，因为它的前缀是$ sign。释放鼠标按钮后，再次抓取它并将其拖到右边，以创建一个完整的比率表。然后格式化此表以显示%。如需进一步参考，请参阅此处。