1、首先在excel表格的单元格中输入需要计算所占比例的数据。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/18d8bc3eb13533fab1a3c861a6d3fd1f41345b63?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
2、然后在C1单元格中输入占比计算公式:=B2/810,意思是用“本科人数”除以总人数。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/838ba61ea8d3fd1f761cf9753e4e251f95ca5f63?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
3、点击回车即可生成计算结果,双击其右下角的绿色圆点可以批量生成计算结果。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/500fd9f9d72a6059f0f4b9552634349b023bba9d?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/9d82d158ccbf6c81ae2277a7b23eb13533fa4063?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
5、右键点击单元格选择设置单元格格式,在打开的对话框中选择“百分比”,并将小数位数选择为“2”,点击确定。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/42a98226cffc1e170faad77e4490f603738de96c?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
6、即可将所占比例的数值更改为百分比显示。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/f7246b600c338744242177335f0fd9f9d62aa09d?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
追问有没有简约一点的公式
本回答被网友采纳