1. 首先,在第一个月的标签输入1,即B4


2. 然后在C3输入以下函数

              =SUM($B$2:C2)-5000*SUM($B$4:B4)
            

3. 然后在C4输入以下函数

              =IF(C3>=0,1,"")
            

4. 拷贝C3和C4,往右粘贴填满


5. 完成

Source: ---

---

Disclaimer: The information in this webpage is shared by anonymous users from external online sources. We cannot guarantee its accuracy or truthfulness. Users should exercise caution and verify information independently.

---