早教吧作业答案频道 -->其他-->
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函数...的网友还看了以下：
1:如图,用与竖直方向成30度角的力F将重为10N的物体推靠在光滑的竖直墙上,求当物体沿着墙匀速滑 2020-04-27 …
matlab中怎么用将矩阵当成自变量带入函数运算?function [ DurF,AngF ] = 2020-05-16 …
c语言 当x0时 y=1y=-1;if(x!=0)if(x>0)y=1;elsey=0;这是程序的 2020-05-16 …
一个关于求导数的答案不明白的地方求f(x)=2x^2+x-1(x>0)的反函数在x=2处的切线的斜 2020-06-06 …
设函数f（x）在x=0处连续，下列命题错误的是（）A．若limx→0f(x)x存在，则f（0）=0 2020-06-12 …
heaskedherifshehadenjoyedthespeech.请问if在这里属于什么语法点 2020-06-18 …
已知函数.其中.（1）若曲线y＝f(x)与y=g(x)在x＝1处的切线相互平行,求两平行直线间的距 2020-07-21 …
求EXCELif函数高手(有关超过7个条件的）,=IF(A1=1,"A",IF(A1=2,"B", 2020-07-23 …
物理学中滑动摩擦力的大小计算公式为f=μN，式中μ叫动摩擦因素，N为正压力，现有一物体G受到向右水 2020-08-02 …
[求助]函数突破了7层,如何换种方法表示?=IF(X3>0,"A",IF((W3+V3)>0,"B" 2020-10-31 …