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="中级及普

来源：学生作业帮助网 编辑：作业帮 时间：2024/11/24 16:36:51
EXCEL2003 if函数只有7组,8个IF怎么用?=IF(AND(F7=
xOP' b€e0%bL4 ȂcRf7Ecc  䏡}_ލth=4>{u^?{LM—* %IoR^R$|P. JDw9>{)"dv!dU[UJva rVB]F!Y:0`2lZ$v]#zA%H<瘘l-y]oMˠk7m`e2V ݜ*#-K>Y`sXXo ,@1ȥ`oC::r*K,-ռ,賚VwfX܇JgXzƬe4;׺Kcѱ/:}_} >s~=w5\=G?N+}A޽ @-xdM+SCj+"ȥ dc[o) Ro|pZQrD){\9 ˊB˸C!MʰO܂ ]:%b+Li+:::6/a*0ځL F<DtmNaqqb\gqH2_7 F^йa(8G'K2J3GRI<"qᰣ H>m}TvK(v2DNՓ3Sn" hƭC:&!a{>fzV%QciBR 2) d# eE^,D"EY*]MMFdF]"/)6[!{0uez~x:A6+\$"I#HW2,{yB!Fdۤ-7 ZY; "DKxDIAD1$`|

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))))
以上两组函数怎么合并或实现以上功能?

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="中级及普
这样试一下是不是你要的公式
=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.05,IF(F7="小型",0.02,)))),""))
或
=IF(G7="高级",VLOOKUP(F7,{"特大型",0.03;"大型",0.01;"中型",0.05;"小型",0.02},2,),IF(G7="中级及普通级",VLOOKUP(F7,{"特大型",0.03;"大型",0.01;"中型",0.05;"小型",0.02},2,),""))

使用vba编辑个函数吧。或是用建立一个表格或数组专门用于这个查询然后用vlookup。
我仔细看了您的公式，发现可以这样写=IF(AND(F7="特大型",OR(G7="高级",G7="中级及普通级")),0.03,IF(AND(F7="大型",OR(G7="高级",G7="中级及普通级")),0.01,IF(AND(F7="中型",OR(G7="高级",G7="中级及普通级")),0.0...

全部展开

使用vba编辑个函数吧。或是用建立一个表格或数组专门用于这个查询然后用vlookup。
我仔细看了您的公式，发现可以这样写=IF(AND(F7="特大型",OR(G7="高级",G7="中级及普通级")),0.03,IF(AND(F7="大型",OR(G7="高级",G7="中级及普通级")),0.01,IF(AND(F7="中型",OR(G7="高级",G7="中级及普通级")),0.05,IF(AND(F7="小型",OR(G7="高级",G7="中级及普通级")),0.02,"错误"))))
另外，最后一个IF中，您写的两个代码有冲突呀。
原因是您的数据大部分都是重复的。如果不重复就只能用上面的两种办法了。

收起

在2003中是没有办法的，只能嵌套6层

=IF(AND(F7="特大型",or(G7="高级",G7="中级及普通级"),0.03,IF(AND(F7="大型",or(G7="高级"，G7="中级及普通级"),0.01,IF(AND(F7="中型",or(G7="高级",G7="中级及普通级"),0.05,IF(AND(F7="小型",or(G7="高级",G7="中级及普通级")),0.02,"错误"))))

第一个公式写到某列（如H列）、错误改为0、
第二个公式写到第一个公式的后一列（I列）
在第二个公式后面（J列）写=H1+I1

从你的公式来看，你根本就不管G7是什么，只按F7进行判断即可
=if(f7="特大型",0.03,if(f7="大型",0.01,if(f7="中型",0.05,if(f7="小型",0.02,"错误"))))
这样只需要四层即完成了

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函数该如何使用, excel2003 IF函数问题要实现以下目的A1 在EXCEL2003中IF函数有哪些用法 excel2003中求和的函数是什么A sum B Average C if D Brow excel2003 if 函数怎么用?成绩大于等于270的为优秀 excel2003函数if公式怎么嵌套超过7层?=IF(E4=0,H4, IF (E4=0.5,I4, IF (E4=1,J4, IF (E4=1.5,K4, IF (E4=2,L4, IF (E4=2.5,M4, IF (E4=3,N4, IF (E4=3.5,O4, IF (E4=4,P4, IF (E4=4.5,Q4, IF (E4=5,R4, IF (E4=5.5,S4, IF (E4>=6,T4))))))))))))) 这个 excel2003函数公式 怎么隐藏 Excel2003中的IF公式是什么意思?怎么应用? 在Excel2003函数中问号的作用是什么?如在公式IF(AB4=?,,IF(U4,,AB4+1)中,代表什么? excel2003 求和函数 要求A1和A2的和,A2是一个IF函数计算出来的,不能用=SUM（A1,A2)了,怎么办? EXCEL2003如何利用函数计算年龄 怎么样用Excel2003做正弦函数图像? 公式：=IF(ISERROR(SUM(D3:D7)/(COUNT(D3:D7)*10)),N/A,SUM(D3:D7)*100/(COUNT(D3:在excel2003中,最好将IF函数和ISERROR函数与总内容连在一起解释,请详细一些, 下面excel函数的含义是 =IF(M7=-,-,IF(P7=-,-,IF(N7=,-,ROUND(SUM(M7*(1+P7)/N7),1))))这是excel2003表格的函数,请问下面函数具体是什么意思,=IF(M7=-,-,IF(P7=-,-,IF(N7=,-,ROUND(SUM(M7*(1+P7)/N7),1)))) Adams中if函数的自变量是不是只有time excel2003函数countif统计各科成绩大于80 excel20007中哪个函数是对应EXCEL2003中的傅里叶分析