excel表中，A列人员姓名，B列人员年龄，C列填写人员所处年龄阶段，求高手解答！

Question

C列返回的值为“21~30岁”、“31~30岁”、“41~50岁”、“51~60岁”

Answer 1

c2公式
=if(b1>=21,if(b1<31,"21~30岁",if(b1<41,"31~40岁",if(b1<51,"41~50岁",if(b1<61,"51~60岁","60岁以上")))))

或者
=if(b1>20,lookup(b1,{21,31,41,51},{"21~30岁","31~30岁","41~50岁","51~60岁"}))

Answer 2

用高级筛选操作