早教吧作业答案频道 -->其他-->
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函数...的网友还看了以下：
if和and/or函数的运用?为什么if有时和and/or连用?and/or启什么作用? 2020-05-22 …
23人身高由高到低排成一排,前5人平均身高比前8人高3厘米,后15人平均身高比后18人低0.5厘米 2020-06-15 …
一道关于对数函数的问题,设x属于[2,8],函数f(x)=(1/2)*[loga(ax)]*[lo 2020-07-21 …
37若函数f(x)的定义域-1,1,则函数f(log二分之一x)的定义域是（底数是二分之一真数是x 2020-07-30 …
一间房子长14.3米,宽5.9米,高3.8米,请问怎样计算面积?一般房子的高度是3米,我要求高出的 2020-07-31 …
对数函数问题(已解出一大半了)设x∈[2,8]函数f(x)=1/2loga(ax)·loga(a^ 2020-08-02 …
某市“安居工程”新建成的一批楼房都是8层高，房子的价格y（元/m2）随楼层数x（楼）的变化而变化（x 2020-12-06 …
某市“安居工程”新建成的一批楼房都是8层高，房子的价格y（元/平方米）随楼层数x（楼）的变化而变化（ 2020-12-06 …
某市“安居工程”新建成的一批楼房都是8层高，房子的价格y（元/平方米）随楼层数x（楼）的变化而变化（ 2020-12-23 …
兰州市“安居工程”新建成的一批楼房都是8层高，房子的价格y（元/平方米）随楼层数x（楼）的变化而变化 2020-12-23 …