excel计算百分比的方法如下:
工具:magicbook
系统:Windows 11
软件:WPS OFFICE
1、选中总和单元格,输入函数“=SUM(F9:J9)”,输入完成后,使用填充柄填充表格,算出所有成绩的总和。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/caef76094b36acafb33b646f6ed98d1000e99c4e?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
2、在单元格中输入公式“=[@数学]/[@总分]”,学生1的数学分数占总分的百分比,然后使用填充柄下拉填充。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/f2deb48f8c5494ee4bf9fd8a3ff5e0fe98257e4e?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
3、选中数据列,右键选择“设置单元格格式”,在弹出框中选择分类为“百分数”,右侧可修改小数位数,设置位数为“2”。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/f11f3a292df5e0fe26c37b924e6034a85fdf724e?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
4、点击确定后,即可完成百分比的设置,看下最终的样式。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/8cb1cb134954092315b291ed8058d109b2de494e?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)