早教吧作业答案频道 -->其他-->
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)x-1/0.3-2x=0.1x+0.2/0.05 (2)0.1x-0.3/ 2020-05-13 …
霍夫曼编码 c语言程序 求能运行的能算出结果的已知信源:s1=0.20,s2=0.18,s3=0. 2020-05-13 …
EXCEL里,如果A1小于等于0.050,则B1为=50*A1/0.05,如果A1小于等于0.15 2020-05-17 …
分别求dy/dx:Y=(-0.5e)^(-1.05-0.15X)+(-0.5e)^(0.12X-1 2020-06-09 …
EXCEL2003 if函数只有7组,8个IF怎么用?=IF(AND(F7="特大型",G7="高 2020-06-27 …
运筹学建模产品1234567利润10634193磨床0.50.7--0.30.20.5立钻0.12 2020-06-28 …
数值0.0000105用科学记数法表示为()A.1.05×104B.0.105×10-4C.1.0 2020-07-18 …
五(1)班同学在一次体育课中测试了跳高成绩(单位:m)。1.20,1.10,1.15,0.95,0. 2020-10-30 …
某零件从毛坯到成品,一共要经过六道自动加工工序,如果各道工序出次品的概率依次为0.01,0.02,0 2020-12-01 …
扩孔钻头怎么磨.要求钻29.7(+0.05到0.1).孔内表面光滑,粗糙度在6.3左右.主要钻14m 2020-12-03 …