EXCEL 会计数字运算 如何在excel中计算财务函数公式
\u7528Excel\u505a\u4f1a\u8ba1\u8ba1\u7b97\uff0c\u4f46\u662f\u8ba1\u7b97\u548c\u7684\u65f6\u5019\u663e\u793a\u7684\u6570\u6570\u503c\u660e\u663e\u4e0d\u6b63\u786e\uff0c\u8fd9\u662f\u4e3a\u4ec0\u4e48\u5462\uff1f14 700 ;3 500; 2 380;\u8fd9\u4e9b\u90fd\u4e0d\u662f\u6570\u503c\u7c7b\u578b\u3002 \u53ea\u6709800 220 \u662f\u6570\u503c\u7c7b\u578b\uff0c\u6c42\u548c\u5f97800+220=1020
\u5bf9\u7b56 \u9009\u4e2dC\u5217 CTRL+H ---->\u67e5\u627e\u5185\uff1a\u6309\u4e00\u6b21\u7a7a\u683c\u952e -----> \u5168\u90e8\u66ff\u6362 --->\u7136\u540e\u5e94\u8be5\u53ef\u4ee5\u8ba1\u7b97\u4e86\uff01
\u4e0b\u9762\u7b80\u5355\u5217\u51fa\u8d22\u52a1\u51fd\u6570\u7684\u79cd\u7c7b\u548c\u4f7f\u7528\u65b9\u6cd5\uff0c\u5177\u4f53\u7684\u5185\u5bb9\u53ef\u4e0b\u8f7d\u672c\u9898\u9644\u4ef6\u53c2\u8003\uff1a
\u6295\u8d44\u8ba1\u7b97
\u3000\u3000\uff081\uff09FV\uff1a\u7528\u9014\uff1a\u57fa\u4e8e\u56fa\u5b9a\u5229\u7387\u53ca\u7b49\u989d\u5206\u671f\u4ed8\u6b3e\u65b9\u5f0f\uff0c\u8fd4\u56de\u67d0\u9879\u6295\u8d44\u7684\u672a\u6765\u503c\u3002
\u3000\u3000\u8bed\u6cd5\uff1aFV(rate,nper,pmt,pv,type)
\u3000\u3000\u53c2\u6570\uff1arate\u4e3a\u5404\u671f\u5229\u7387\u3002nper\u4e3a\u603b\u6295\u8d44\u671f\u3002pmt\u4e3a\u5404\u671f\u5e94\u4ed8\u91d1\u989d\u3002pv\u4e3a\u73b0\u503c\u6216\u4e00\u7cfb\u5217\u672a\u6765\u4ed8\u6b3e\u7684\u5f53\u524d\u503c\u7684\u7d2f\u79ef\u548c\uff0c\u4e5f\u79f0\u4e3a\u672c\u91d1\u3002type\u4e3a\u6570\u5b570\u62161\uff080\u4e3a\u671f\u672b\uff0c1\u4e3a\u671f\u521d\uff09\u3002
\u3000\u3000\u793a\u4f8b\uff1a\u5982\u679cA1=6%\uff08\u5e74\u5229\u7387\uff09\uff0cA2=10\uff08\u4ed8\u6b3e\u671f\u603b\u6570\uff09\uff0cA3=-100\uff08\u5404\u671f\u5e94\u4ed8\u91d1\u989d\uff09\uff0cA4=-500\uff08\u73b0\u503c\uff09\uff0cA5=1\uff08\u5404\u671f\u7684\u652f\u4ed8\u65f6\u95f4\u5728\u671f\u521d\uff09\uff0c\u5219\u516c\u5f0f\u201c=FV(A1/12,A2,A3,A4,A5)\u201d\u8ba1\u7b97\u5728\u4e0a\u8ff0\u6761\u4ef6\u4e0b\u6295\u8d44\u7684\u672a\u6765\u503c\u3002
\u3000\u3000\uff082\uff09PV\uff1a\u7528\u9014\uff1a\u8fd4\u56de\u6295\u8d44\u7684\u73b0\u503c(\u5373\u4e00\u7cfb\u5217\u672a\u6765\u4ed8\u6b3e\u7684\u5f53\u524d\u503c\u7684\u7d2f\u79ef\u548c)\u3002
\u3000\u3000\u8bed\u6cd5\uff1aPV(rate,nper,pmt,fv,type)
\u3000\u3000\u53c2\u6570\uff1arate\u4e3a\u5404\u671f\u5229\u7387\u3002nper\u4e3a\u603b\u6295\u8d44\uff08\u6216\u8d37\u6b3e\uff09\u671f\u6570\u3002pmt\u4e3a\u5404\u671f\u6240\u5e94\u652f\u4ed8\u7684\u91d1\u989d\u3002fv\u4e3a\u672a\u6765\u503c\u3002type\u4e3a\u6570\u5b570\u62161\uff080\u4e3a\u671f\u672b\uff0c1\u4e3a\u671f\u521d\uff09\u3002
\u3000\u3000\u793a\u4f8b\uff1a\u5982\u679cA1=500\uff08\u6bcf\u6708\u5e95\u4e00\u9879\u4fdd\u9669\u5e74\u91d1\u7684\u652f\u51fa\uff09\uff0cA2=8%\uff08\u6295\u8d44\u6536\u76ca\u7387\uff09\uff0cA3=20\uff08\u4ed8\u6b3e\u5e74\u9650\uff09\uff0c\u5219\u516c\u5f0f\u201c=PV(A2/12,12*A3,A1,,0)\u201d\u8ba1\u7b97\u5728\u4e0a\u8ff0\u6761\u4ef6\u4e0b\u5e74\u91d1\u7684\u73b0\u503c\u3002
\u3000\u30002.\u672c\u91d1\u548c\u5229\u606f
\u3000\u3000\uff081\uff09PMT\uff1a\u7528\u9014\uff1a\u57fa\u4e8e\u56fa\u5b9a\u5229\u7387\u53ca\u7b49\u989d\u5206\u671f\u4ed8\u6b3e\u65b9\u5f0f\uff0c\u8fd4\u56de\u6295\u8d44\u6216\u8d37\u6b3e\u7684\u6bcf\u671f\u4ed8\u6b3e\u989d\u3002
\u3000\u3000\u8bed\u6cd5\uff1aPMT(rate,nper,pv,fv,type)
\u3000\u3000\u53c2\u6570\uff1arate\u8d37\u6b3e\u5229\u7387\u3002nper\u8be5\u9879\u8d37\u6b3e\u7684\u4ed8\u6b3e\u603b\u6570\u3002pv\u4e3a\u73b0\u503c\uff08\u4e5f\u79f0\u672c\u91d1\uff09\u3002fv\u4e3a\u672a\u6765\u503c\u3002type\u4e3a\u6570\u5b570\u62161\uff080\u4e3a\u671f\u672b\uff0c1\u4e3a\u671f\u521d\uff09\u3002
\u3000\u3000\u793a\u4f8b\uff1a\u5982\u679cA1=8%\uff08\u5e74\u5229\u7387\uff09\uff0cA2=10\uff08\u652f\u4ed8\u7684\u6708\u4efd\u6570\uff09\uff0cA3=10,000\uff08\u8d37\u6b3e\u989d\uff09\uff0c\u5219\u516c\u5f0f\u201c=PMT(A1/12,A2,A3)\u201d\u8ba1\u7b97\u5728\u4e0a\u8ff0\u6761\u4ef6\u4e0b\u8d37\u6b3e\u7684\u6708\u652f\u4ed8\u989d\u3002
\u3000\u3000\uff082\uff09IPMT\uff1a\u7528\u9014\uff1a\u57fa\u4e8e\u56fa\u5b9a\u5229\u7387\u53ca\u7b49\u989d\u5206\u671f\u4ed8\u6b3e\u65b9\u5f0f\uff0c\u8fd4\u56de\u6295\u8d44\u6216\u8d37\u6b3e\u5728\u67d0\u4e00\u7ed9\u5b9a\u671f\u9650\u5185\u7684\u5229\u606f\u507f\u8fd8\u989d\u3002
\u3000\u3000\u8bed\u6cd5\uff1aIPMT(rate,per,nper,pv,fv,type)
\u3000\u3000\u53c2\u6570\uff1arate\u4e3a\u5404\u671f\u5229\u7387\u3002per\u7528\u4e8e\u8ba1\u7b97\u5176\u5229\u606f\u6570\u989d\u7684\u671f\u6570\u3002nper\u4e3a\u603b\u6295\u8d44\u671f\u6570\u3002pv\u4e3a\u73b0\u503c\uff08\u672c\u91d1\uff09\u3002fv\u4e3a\u672a\u6765\u503c\u3002type\u4e3a\u6570\u5b570\u62161\uff080\u4e3a\u671f\u672b\uff0c1\u4e3a\u671f\u521d\uff09\u3002
\u3000\u3000\u793a\u4f8b\uff1a\u5982\u679cA1=10%\uff08\u5e74\u5229\u7387\uff09\uff0cA2=1\uff08\u7528\u4e8e\u8ba1\u7b97\u5176\u5229\u606f\u6570\u989d\u7684\u671f\u6570\uff09\uff0cA3=3\uff08\u8d37\u6b3e\u7684\u5e74\u9650\uff09\uff0cA4=8000\uff08\u8d37\u6b3e\u7684\u73b0\u503c\uff09\u5219\u516c\u5f0f\u201c=IPMT(A1/12,A2*3,A3,A4)\u201d\u8ba1\u7b97\u5728\u4e0a\u8ff0\u6761\u4ef6\u4e0b\u8d37\u6b3e\u7b2c\u4e00\u4e2a\u6708\u7684\u5229\u606f\u3002
AA3的公式：
=IF(LEN(CONCATENATE($A3,$B3,$C3,$D3,$E3,$F3,$G3,$H3,$I3,$J3,$K3,$L3,$M3)-CONCATENATE($N3,$O3,$P3,$Q3,$R3,$S3,$T3,$U3,$V3,$W3,$X3,$Y3,$Z3))>(COLUMN($M3)-COLUMN(A3)),TEXT(MID(TEXT(CONCATENATE($A3,$B3,$C3,$D3,$E3,$F3,$G3,$H3,$I3,$J3,$K3,$L3,$M3)-CONCATENATE($N3,$O3,$P3,$Q3,$R3,$S3,$T3,$U3,$V3,$W3,$X3,$Y3,$Z3),"0000000000000"),COLUMN(A1),1),"0"),"")
向右填充，再整个向下填充
建议将收、支、余分别用三个字段处理，这样比较直观以及可以直接运算，而你需要的图是作成账目表的式样，可以用语句加将数字转换处理后写入相应的格子，用if语句判断去掉前面的0
这个简单，先将单元格的格式改成文本的，输数字就不会把前面的零去掉了，即选中单元格，单击右键->数字->文本。
=IF(LEN(CONCATENATE($A3,$B3,$C3,$D3,$E3,$F3,$G3,$H3,$I3,$J3,$K3,$L3,$M3)-CONCATENATE($N3,$O3,$P3,$Q3,$R3,$S3,$T3,$U3,$V3,$W3,$X3,$Y3,$Z3))>(COLUMN($M3)-COLUMN(A3)),TEXT(MID(TEXT(CONCATENATE($A3,$B3,$C3,$D3,$E3,$F3,$G3,$H3,$I3,$J3,$K3,$L3,$M3)-CONCATENATE($N3,$O3,$P3,$Q3,$R3,$S3,$T3,$U3,$V3,$W3,$X3,$Y3,$Z3),"0000000000000"),COLUMN(A1),1),"0"),"")鐧惧害鍦板浘
不好意思,不怎么明白您要干吗,算出余额的话你直接用EXCEL的公式拉一下不就可以了么,至于去零,你把格式设置成会计格式即可
扩展阅读：excel 重复人名 计数 ... 会计科目编码表2024 ... 会计科目全部代码表 ... excel 按人名 汇总金额 ... excel 年份 转换为数字 ... excel表格e+怎么改成数字 ... excel 自动计算 ... excel 重复项 计数 ... excel 怎么递增数字 ...
