作业帮 > 综合 > 作业

EXCEL2003 if函数只有7组,8个IF怎么用?

来源：学生作业帮 编辑：搜搜做题作业网作业帮 分类：综合作业 时间：2024/05/06 06:21:46
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(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,),""))
EXCEL2003 if函数只有7组,8个IF怎么用? excel2003 if 函数怎么用? excel2003 IF函数问题 excel2003函数if公式怎么嵌套超过7层? excel2003中IF函数该如何使用, 如何操作excel2003中的用以排名次的函数if IF,LOOKUP函数怎么用,可以给个实例吗? 怎么用IF函数计算分段函数 if函数怎么做? 在Excel2003函数中问号的作用是什么?如在公式IF(AB4="?","",IF(U4"","",AB4+1)中,代 怎么用if 函数设置公式 EXECL中的IF函数怎么用