幼儿园分组好听的名字

F2=LOOKUP(D2,--{0,"2011-9-2","2012-9-2"},{"大班","中班","小班"})

或=IF(D2<--"2011-9-2","大班",IF(D2<--"2012-9-2","中班","大班"))

下拉

---

　　F
=IF(OR(D2<DATE(2010,9,1),D2>DATE(2013,8,31)),"不在规定的时间内",IF(D2<DATE(2011,9,1),"小班",IF(D2<DATE(2012,9,1),"中班","大班")))
下拉

网友在看

---

友情链接

首页 | 帝一起名 | 帝一辞典