1、根据图示,已知本次余额16304.24,每行都需要自动计算黄色框内的“本次余额”:
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/1c950a7b02087bf4a52704e7fcd3572c10dfcff1?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
2、本次余额D3=上次余额D2+本次收入金额B3-本次支出金额C3,公式如黄框中所示:
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/0b46f21fbe096b630031295d02338744ebf8ac97?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
3、输入以上公式后按回车键即可得出第三行的本次余额D3为16254.44
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/94cad1c8a786c917135c2634c73d70cf3bc7575b?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
4、把鼠标放在上图的红框处,看到一个黑色十字架时,直接往下拉,拉到表格数据最后一行,选中“复制单元格”,即代表本次余额D列已经默认有自动计算本次余额的公式:
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/b90e7bec54e736d11fc9fa0595504fc2d46269e0?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
5、随便选中一个红框鼠标双击进入检查公式,可以看见D5=D4+B5-C5,此列公式规律全部一样,就可以自动计算余额了。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/e4dde71190ef76c69cf98c269316fdfaaf516797?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)