=1,A1<=20000),0.01,IF(AND(A1>20000,A1<=60000),0.02,0.03)))-" />

Excel区间数据乘以对应值的公式

用户提问 |浏览1352次
收藏|2019/03/31 12:26

满意回答

2019/03/31 12:51

假设数据在A1,那么在需要计算系数的单元格输入公式:=IF(A1<1,"",IF(AND(A1>=1,A1<=20000),0.01,IF(AND(A1>20000,A1<=60000),0.02,0.03)))
匿名

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

 加载中...