Home  >  Article  >  Topics  >  How to calculate percentage in table

How to calculate percentage in table

醉折花枝作酒筹
醉折花枝作酒筹Original
2021-04-29 14:19:35138737browse

Operation method: First open the excel table, select the cells that need to be operated; then right-click the mouse and select "Format Cells" - "Number" - "Percent" in the right-click menu; finally, in the cell Enter the formula "divisor cell/dividend cell" into the cell and press the "Enter key" on the keyboard.

How to calculate percentage in table

The operating environment of this tutorial: windows7 system, WPS Office2019 version, Dell G3 computer.

First click to open the excel table. After opening the software, enter the table window.

How to calculate percentage in table

Select column D, right-click--Format Cells

How to calculate percentage in table

Select "Number"--"Percent ” and set the number of decimal places (the default is two decimal places)

How to calculate percentage in table

Enter in D2: =b2/c2, press Enter, and then pull down the fill handle to fill the table That’s it.

How to calculate percentage in table

How to calculate percentage in table

Related learning recommendations: excel tutorial

The above is the detailed content of How to calculate percentage in table. For more information, please follow other related articles on the PHP Chinese website!

Statement:
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn