易表在线答疑技术与交流用户社区 → 如何才能够在光标指所在单元格自动录入数字,使借贷平衡呢?


  共有10149人关注过本帖树形打印复制链接

主题:如何才能够在光标指所在单元格自动录入数字,使借贷平衡呢?

帅哥哟,离线,有人找我吗?
还不错
  1楼 | 信息 | 搜索 | 邮箱 | 主页 | UC


加好友 发短信
等级:火箭侠 帖子:1937 积分:283 威望:0 精华:0 注册:2006/8/12 9:40:00
  发帖心情 Post By:2009/3/7 11:30:00 [显示全部帖子]

参考一下,我的金额录入公式:
if([记账凭证!录入明细] = - 1 And [记账凭证!项目核算]=-1,round(SumFor(Substitute([记账凭证!科目名称]," ","")+"-本年发生","金额","凭证号","=",[记账凭证!凭证号],"项目名称","=",[记账凭证!明细科目],"借贷","=",[记账凭证!借贷]),2),if(text([记账凭证!金额])="+",cell(row-1,col,"记账凭证"),if(text([记账凭证!金额])="++",if([记账凭证!借贷]=0,round(SumFor("记账凭证","金额","凭证号","=",[记账凭证!凭证号],"借贷","=",-1)-SumFor("记账凭证","金额","凭证号","=",[记账凭证!凭证号],"借贷","=",0),2),round(SumFor("记账凭证","金额","凭证号","=",[记账凭证!凭证号],"借贷","=",0)-SumFor("记账凭证""金额","凭证号","=",[记账凭证!凭证号],"借贷","=",-1),2)),if([金额]=0,"",[金额]))))

 回到顶部
帅哥哟,离线,有人找我吗?
还不错
  2楼 | 信息 | 搜索 | 邮箱 | 主页 | UC


加好友 发短信
等级:火箭侠 帖子:1937 积分:283 威望:0 精华:0 注册:2006/8/12 9:40:00
  发帖心情 Post By:2009/3/7 13:05:00 [显示全部帖子]


 回到顶部