求助excel脚本编辑
判断出来
10岁下 小朋友 (分出男女)
10-19 同学
20-50 先生 女士
50-80 叔叔 阿姨
80- 爷爷 婆婆
[解决办法]
=IF(D2<10,"小朋友",IF(D2<19,"同学",IF(D2<49,IF(B2="男","先生","女士"),IF(D2<79,IF(B2="男","叔叔","阿姨"),IF(B2="男","爷爷","婆婆")))))
[解决办法]
=IF(B2="男",IF(D2<10,"男小朋友", IF(D2<20,"男同学",IF(D2<50,"先生",IF(D2<80,"叔叔","爷爷")))), IF(D2<10,"女小朋友", IF(D2<20,"女同学",IF(D2<50,"女士",IF(D2<80,"阿姨","奶奶")))))
[解决办法]
在 E2 单元格粘贴3F的那个公式,然后把公式复制下去。
[解决办法]
你的 20-50 跟 50-80 ,在50岁那儿重合了。
按20-49、50-80处理的。