上期利润为负或为零的情况下,是不计算增长率的,可以使用增长值来代替。
计算增长值和增长率的方法:
1、按照顺序将需要计算的数据列入单元格,在B2单元格中输入“=B1-A1”。点击回车即可得到增长值,该值只针对上期利润为负或为零的情况下。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/42a98226cffc1e17a49f7c9f4490f603738de978?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
2、然后计算增值率,输入公式=(C1-B1)/B1。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/f703738da977391285d074cff6198618377ae2ae?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/dcc451da81cb39dbbe0e96f8de160924aa183055?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/34fae6cd7b899e511dbccaba4ca7d933c8950d69?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
5、或者可以使用增值率公式:=TEXT((C1-B1)/B1,"0%"),即可直接生成百分比的数据。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/9a504fc2d56285355004238f9eef76c6a6ef63bc?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)