Question

excel中if函数嵌套怎么用

当af5是“是”时，B5<=40,AG5=0.15,40<B5<=70,AG5=0.20,70<B5<=130,AG5=0.25,B5>130,AG5=0.30
这个公式怎么弄
当af5不是"是"，ag5=0

Answer 1

输入等于IF函数，选择判断的单元格，输入大于等于和条件，逗号，双引号，输入条件成立返回优秀。在复制公式，粘贴到后面改为条件，优秀改为良好，在复制公式，把修改条件，良好改为及格，输入一个为不及格，补齐三括号确定即可。

Answer 2

=if(AF5="是",if(b5<=40,0.15,if(b5<=70,0.20,if(b5<=130,0.25,0.30))),0)
AG5里输入上面公式！

Answer 3

=if(B5<=40,0.15,if(B5<=70,0.20,if(B5<=130,0.25,0.30)))

Answer 4

if函数嵌套