表格嵌套公式

分类:公式学习浏览量:2536发布于:2021-05-06 22:28:14

如果要用if函数,请试试下面的公式: =if(g3="a",sheet2!c20,if(g3="b",sheet2!c6,if(g3="c",sheet2!c7,if(g3="d",sum(sheet2!c8:c10),if(g3="e",sheet2!c11,if(g3=

假设成绩在a1单元格,90以上为优,80以上为良,70以上为中,那么公式可以写为:=if(a1>=90,“优”,if(a1>=80,"良",if(a1>=70,"中",if(a1>=60,"及格","不及格"))))

只要一个公式中的参数 与另一个公式的返回值类型一致,一般都能用,比如:=MID(A1,2,LEN(A1)-3)再如:=IF(A2>3,IF(A1 评论0 0 0

=LOOKUP(A1,{0,10,12,15,18,23,30,50,70},{0,0.01,0.011,0.012,0.013,0.014,0.015,0.016,0.017})

如果要用IF函数,请试试下面的公式: =IF(G3="A",Sheet2!C20,IF(G3="B",Sheet2!C6,IF(G3="C",Sheet2!C7,IF(G3="D",SUM(Sheet2!C8:C10),IF(G3="E",

=IF(A1>=340,"优",IF(A1>=280,"良",IF(A1>=240,"中","差")))

这个时间不好弄很简单加个E列 =month(对应C列)得到C列的月份在用公式 =countifs(D:D,"=活动中",E:E,"=4") 得到客户数量=if(b4>$b$3,100-(e4*100*1.5),100+(e4*100*1))请上传个例子!

=if(AND(OR(B47=1,B47=2,B47=6,AND(B47>39,B47<44)),D47=1,E47>5,E47<14),0.173,if(AND(OR(B47=2,B47=1,B47=6,B47>39,B47<44),D55=2,E47>5,E47<14),0.175,if(AND(OR(B47=3,B47=4,B47=5,B47=7,B47=10,B47=11,B47>13,B47<17),D47=2,E47>5,E47<14),0.177,0.171)))

你好,你可以这样来写函数,如下图所示:比如A2就是你的注册资金,我们在B3输入相关的函数:=IF(A2=3000,"0",IF(A2<3500,"1",IF(A2<4000,"2","3")))这样就可以在B3得到你相应的分数

=if(A1="","",A1) 补充一句,两个或以上的if函数一起使用才能算得上是嵌套.还有不清楚的地方,兄弟可以随时Hi我.