D列显示的是每个人的年龄,E列显示的是每个人的性别,F列要输入EXCEL公式。

2024-11-25 17:47:37
推荐回答(1个)
回答1:

=IF(E1="男",LOOKUP(D1,{16,35,50,60},{"二段","三段","四段","旅毕让五段"}),LOOKUP(D1,{16,30,45,55},{"二段","三段","数燃四拆局段","五段"}))