Excel if函数判断某个日期是否在某个区间内?答:你要的公式:=IF(DATEDIF(A2,B2,"m")<6,"6个月之内",IF(DATEDIF(A2,B2,"m")<12,"6-12个月内","12个月之上"))如果A列的日期有可能晚于B列的日期,那么在日期计算那里在套上一个IFERROR函数来调换一下起止日期就好了,=IF(IFERROR(DATEDIF(A2,B2,"m"),DATEDIF(B2,A2,"m"))<6,...
用什么函数,是用if函数吗?答:可以用VLOOKUP来写,效果如下:B1公式为:=IFERROR(VLOOKUP(A1,{"北京","一类";"上海","一类";"深圳","一类";"杭州","二类";"南京","二类";"长沙","二类"},2,0),"三类")&"机场"