excel中根据年1980年自动判断为80后,无月日,只有年,分段为70后,80后,85后,90后,95后,00后
60后的不管吗?
=IF(YEAR(A2)<1979,"70后",IF(YEAR(A2)<1985,"80后",IF(YEAR(A2)<1990,"85后",IF(YEAR(A2)<1994,"90后",IF(YEAR(A2)<1999,"95后","00后")))))
N能否讲解一下这条命令,并且如果数列当中无年份是空白,能否直接判断空白
追答=IF(A1="","",RIGHT(LOOKUP(A1,{1970,1980,1985,1990,1995,2000})&"后",3))
查找A1的值,在数组{1970,1980,1985,1990,1995,2000}中查找小于A1的最大值。