会计余额函数vba

=TEXT(LEFT(A15,IFERROR(FIND(".",A15),LEN(A15))),"[DBNUM2]")&"元"&IFERROR(TEXT(MID(A15,FIND(".",A15)+1,1),"[DBNUM2]")&IF(--MID(A15,FIND(".",A15)+1,1)=0,"","角"),"")&IFERROR(TEXT(MID(A15,SEARCH(".??",A15)+2,1),"[DBNUM2]")&"分","整")

如果日期在A列，消费在F列，余额在G列，那么前一日余额为=VLOOKUP(TODAY()-1,A:G,7,1)当日支出为=SUMIF(A:A,TODAY(),F:F)组合后公式为=VLOOKUP(TODAY()-1,A:G,7,1)-SUMIF(A:A,TODAY(),F:F)不需要每天再更新日期了。

选中单元格------设置单元格格式------数字中的特殊-------中文大写数字