if函数怎么写多个条件多个结果

360U883849164 |浏览1589次
收藏|2020/02/18 11:13

满意回答

2020/02/18 11:25

是excel中的,以下就可以=IF(A1=24,0.01*B1,IF(A1=36,0.012*B1,IF(A1=48,0.015*B1,IF(A1=60,0.02*B1,0))))

whoami1978

其他回答(0)
0人关注该问题
+1

 加载中...