Henry D. Sy 发表于 2017-9-18 23:55
=IF(J3="发货","",IF(K3="","",K3-N3))
Henry D. Sy 发表于 2017-9-19 11:59
=IF(OR(J3="发货",L3="正常发货"),"",IF(K3="","",K3-N3))
hncnxh 发表于 2017-9-19 14:25
原来是这样,那如果只需要判断J3=发货跳过不计算,怎么写
欢迎光临 Office中国论坛/Access中国论坛 (http://www.office-cn.net/) | Powered by Discuz! X3.3 |