跪求IF函数大侠=IF(G8>=1.6,0.034,IF(G8>=1.3,0.032,IF(G8>=1.2,0.03,IF(G8>=1.1,0.028,IF(G8>=1,0.026,IF(G8>=0.9,0.022,IF(G8>=0.75,0.019,IF(G8>=0.6,0.016,IF(G8>=0.5,0.014,0)))))))))那位大侠帮忙回答一下这个公式是那里错了呀?

题目详情

跪求IF函数大侠
=IF(G8>=1.6,0.034,IF(G8>=1.3,0.032,IF(G8>=1.2,0.03,IF(G8>=1.1,0.028,IF(G8>=1,0.026,IF(G8>=0.9,0.022,IF(G8>=0.75,0.019,IF(G8>=0.6,0.016,IF(G8>=0.5,0.014,0)))))))))那位大侠帮忙回答一下这个公式是那里错了呀?

▼优质解答

答案和解析

大于7个层次了

修改一下：
=LOOKUP(G8,{0,0.5,0.6,0.75,0.9,1,1.1,1.2,1.3,1.6},{0,0.014,0.016,0.019,0.022,0.026,0.028,0.03,0.032,0.034})
这样就可以了

看了跪求IF函数大侠=IF(G8>...的网友还看了以下：

EXCEL IF函数 A数值满足条件(条件比较多),则B等于某数值.请帮忙写一个IF函数,如果A> 　2020-05-16 …

IF函数题求助如果高等数学、大学英语成绩均大于或等于75在备注栏内给出信息“有资格”,否则给出信息　2020-06-18 …

EXCEL2003 if函数只有7组,8个IF怎么用?=IF(AND(F7="特大型",G7="高　2020-06-27 …

EXCEL中用IF函数超过了7层怎么办?IF(C2=0,"",IF(B2="A",VLOOKUP( 　2020-07-08 …

IF函数得出来的数据不能累加怎么办=IF(C3>=109.5%,14.8,IF(C3>=108.5% 　2020-10-31 …

IF条件是INDEX函数得到的结果,能用if函数吗?怎么用?不能的的话,该用什么函数?怎么编辑公式? 　2020-11-01 …

=MIN(IF(A1>{0,200,500,1000},{2,1.5,1.2,1}))*A1,请问：　2020-11-28 …

跪求IF函数大侠=IF(G8>=1.6,0.034,IF(G8>=1.3,0.032,IF(G8>= 　2020-12-08 …

用IF函数如果一个数大于另外一个数就不变,否则就为一个常数比如有一组数：11、20、30、100、1 　2020-12-09 …

if函数的嵌套if函数如何满足多个条件计算,比如说,满足职位,满足入职日期悬赏分：5-离问题结束还i 　2020-12-10 …