怎么用excel函数表示年纪在所属年龄段

Question

就是，有了年纪，想要自动生成 这个年纪所在的年龄段
比如 58岁 所在年龄段是51-60岁
就会自动输入51-60岁

Answer 1

如果你只有一个年龄判断
=if((a1>51)*(a1<60),"51—61岁")

另外 复制以下数据到电子表格 从A1开始存放
在B1输入公式并下拉后可查看年龄分组情况
=LOOKUP(A2,{0,25,30,35,40},{"25以下","25-30(含)","30-35(含)","35-40(含)","40以上"})

******************************************开始复制*******************************************
年龄
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
******************************************复制结束*******************************************

如有问题请详述

Answer 2

=IF(A1="","",IF(A1<21,"0-20岁",IF(A1<31,"21-30岁",IF(A1<41,"31-40岁",IF(A1<51,"41-50岁",IF(A1<61,"51-60岁",IF(A1<71,"61-70岁",IF(A1<81,"71-80岁","81岁以上"))))))))

改进一下到100岁以上,且每十岁一个分组,
=IF(A1="","",IF(A1<51,IF(A1<11,"0-10岁",IF(A1<21,"11-20岁",IF(A1<31,"21-30岁",IF(A1<41,"31-40岁","41-50岁")))),IF(A1<61,"51-60岁",IF(A1<71,"61-70岁",IF(A1<81,"71-80岁",IF(A1<91,"81-90岁",IF(A1<101,"91-100岁","百岁以上""")))))))本回答被提问者采纳