excel脚本编辑

0 0

excel脚本编辑

求助excel脚本编辑

判断出来

10岁下小朋友（分出男女）

10-19 同学

20-50 先生女士

50-80 叔叔阿姨

80- 爷爷婆婆

VisualBasic程序开发环境程序开发 VisualBasic

10 years, 2 months ago

Epony

Epony 10 years, 2 months ago

=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,"阿姨","奶奶")))))

answered 12 years ago

湯淺比吕美

湯淺比吕美 answered 12 years ago

=IF(D2<10,"小朋友",IF(D2<19,"同学",IF(D2<49,IF(B2="男","先生","女士"),IF(D2<79,IF(B2="男","叔叔","阿姨"),IF(B2="男","爷爷","婆婆")))))

answered 12 years ago

绝对魔女34号

绝对魔女34号 answered 12 years ago

你的 20-50 跟 50-80 ，在50岁那儿重合了。

按20-49、50-80处理的。

answered 12 years ago

我们快乐舞B

我们快乐舞B answered 12 years ago

在 E2 单元格粘贴3Ｆ的那个公式，然后把公式复制下去。

answered 12 years ago

Loxias

Loxias answered 12 years ago