How to calculate percentage in table

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.

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.

Select column D, right-click--Format Cells

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

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

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!