excel中当A1里“流动资金贷款、融资租赁”,
excel中当A1里“流动资金贷款、融资租赁”,B1为数量12,在A1为流动资金贷款,B1<=12时,C1为长期借款,当B1>12时,为短期借款,在A1为融资租赁,B1<=12时,C1为长期应付款。
备注:缺少“在A1为融资租赁,B1>12时,C1的赋值”
运行效果图:
C2单元格输入公式:
=IF(AND(A2="流动资金贷款",B2<=12),"长期贷款",IF(AND(A2="流动资金贷款",B2>12),"短期贷款",IF(AND(A2="融资租赁",B2<=12),"长期付款","是不是应该:短期付款?")))
根据备注,修改公式中“是不是应该:短期付款?”
C1=if(b1>12,"短","长")&"期"&if(a1="融资租赁","应付","借")&"款"
热门标签: