跪求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>...的网友还看了以下：

一个卷成圆形的钢板,已知它的密度是7.85,外直径4.260米内直径4.108米高4.985米厚度　2020-04-25 …

甲乙两人同时解方程组{ax+y=3,2x-by=1.甲看错了b,求的解为{x=1,y=-1;乙看错　2020-04-26 …

在解方程组{ax+by=26 cx+y=6 的时候小冲求得正确得解为x=-4 y=-2,但小牛把c 　2020-05-13 …

某同学把7x(囗—3)错抄写为7X囗一3,抄错后计算得到的答案为y.若正确答案为x,某同学把7x( 　2020-05-16 …

小明和小李同解一个二元一次方程组AX+BY=16,BX+AY=1.小明把方程1抄错,求得解X=-1 　2020-06-24 …

丽丽和敏敏同解一道关于x,y的方程组ax+by=16(1),bx+ay=1.(2)丽丽把1抄错了, 　2020-07-31 …

小明和小李同解一个二元一次方程组1.ax+by=16,2.bx+ay=1,小明把方程1抄错,得出解　2020-07-31 …

C语言中,下列不合法的字符常量是A'\xff'B'\65'C'&'D'\028'求解释啊，谢谢大家啦　2020-12-02 …

在计算当x=3时,求代数式3（x的平方-3x+3）-2(x的平方-3x+1）-（x的平方-3x+2）　2020-12-10 …

一份试卷6道题,某学生随机犯了4处不同错误.求①4处错误发生在不同题...一份试卷6道题,某学生随机　2021-01-04 …