早教吧作业答案频道 -->其他-->
EXCEL2003 if函数只有7组,8个IF怎么用?=IF(AND(F7="特大型",G7="高级"),0.03,IF(AND(F7="大型",G7="高级"),0.01,IF(AND(F7="中型",G7="高级"),0.05,IF(AND(F7="小型",G7="高级"),0.02,"错误"))))=IF(AND(F7="特大型",G7="中级及普
题目详情
EXCEL2003 if函数只有7组,8个IF怎么用?
=IF(AND(F7="特大型",G7="高级"),0.03,IF(AND(F7="大型",G7="高级"),0.01,IF(AND(F7="中型",G7="高级"),0.05,IF(AND(F7="小型",G7="高级"),0.02,"错误"))))
=IF(AND(F7="特大型",G7="中级及普通级"),0.03,IF(AND(F7="大型",G7="中级及普通级"),0.01,IF(AND(F7="中型",G7="中级及普通级"),0.05,IF(AND(F7="小型",G7="中级及普通级"),0.02,0))))
以上两组函数怎么合并或实现以上功能?
=IF(AND(F7="特大型",G7="高级"),0.03,IF(AND(F7="大型",G7="高级"),0.01,IF(AND(F7="中型",G7="高级"),0.05,IF(AND(F7="小型",G7="高级"),0.02,"错误"))))
=IF(AND(F7="特大型",G7="中级及普通级"),0.03,IF(AND(F7="大型",G7="中级及普通级"),0.01,IF(AND(F7="中型",G7="中级及普通级"),0.05,IF(AND(F7="小型",G7="中级及普通级"),0.02,0))))
以上两组函数怎么合并或实现以上功能?
▼优质解答
答案和解析
这样试一下是不是你要的公式=IF(G7="高级",IF(F7="特大型",0.03,IF(F7="大型",0.01,IF(F7="中型",0.05,IF(F7="小型",0.02,"错误")))),IF(G7="中级及普通级",IF(F7="特大型",0.03,IF(F7="大型",0.01,IF(F7="中型",0.0...
看了 EXCEL2003 if函数...的网友还看了以下：
级个同学为了探究花生果实大小的变异是什么原因引起i的,进行了实验分别购买大小两个品种的花生,个拿3 2020-05-15 …
设L是xoy平面上的一条光滑曲线弧，函数f（x，y）在L上有界．用L上的点M1，M2，…Mn-1把 2020-05-16 …
You have more friends than I have.这句为什么可以和You hav 2020-05-16 …
实验二小五年级和六年级各有四个班,他们共向地震灾区捐款4800元,实验二小五年级和六年级各有四个班 2020-05-16 …
含有个级、万级、亿级的数,最多是（）位数,最大是（）,最少是（）位数,最小是（含有个级、万级、亿级 2020-05-21 …
怎么过20～10啊，挑战19～5啊本人有满级突3小小剑圣影魔105级的萨尔，都是紫的，还有15级蓝 2020-07-06 …
现有大小形状完全相同的标号为i的i个球（i=1，2，3），现从中随机取出2个球，则取出的这两个球的标 2020-11-07 …
现有大小形状完全相同的标号为i的i个球（i=1,2,3）,现从中随机取出2个球,则取出的这两个球的1 2020-11-07 …
高压输电的原理:Q=I平方×R×t和P=U×I,当P和t一定时减小U才能减小I,从而减小Q,即线损电 2020-11-21 …
实验小学一至四年级兴趣小组情况如下表：年级一年级二年级三年级四年级兴趣小组个数4488平均每组人数2 2021-01-08 …