excel中if函数嵌套公式

2024-11-22 18:51:58

推荐回答（5个）

回答1：

excel2003中if函数嵌套使用方法

回答2：

IF(B1>=0.6,IF(A1>=0.7,0.018,IF(A1>=0.5,0.017,IF(A1>=0.3,0.016,IF(A1>=0.23,0.015,IF(A1>=0.18,0.14,IF(A1>=15,0.013,IF(A1>=12,0.012,IF(A1>=0.1,0.11,0.1)))))))),0)

回答3：

=LOOKUP(A1, {0,10,12,15,18,23,30,50,70}, {"1%","1.1%","1.2%","1.3%","1.4%","1.5%","1.6%","1.7%","1.8%"})

回答4：

输入以下公式
=IF(B1<60%,0,LOOKUP(A1,{0,10,12,15,18,23,30,50,70},{1,1.1,1.2,1.3,1.4,1.5,1.6,1.7,1.8}*1%))

回答5：

IF(B1>=60%,LOOKUP(A1,{0,10,12,15,18,23,30,50,70},{1,1.1,1.2,1.3,1.4,1.5,1.6,1.7,1.8})%,0)