数字条件判断问题B2中数字为1到12的任意一个数,现在C2中输入下列公式,但说有错,请牛人帮忙纠正.（系统说有错的）公式：=IF(B2=1,"4",IF(B2=2,"4",IF(B2=3,"3",IF(B2=4,"3",IF(B2=5,"3",IF(B2=6,"4",IF(B2=7,"5",IF(B

Question

数字条件判断问题
B2中数字为1到12的任意一个数,现在C2中输入下列公式,但说有错,请牛人帮忙纠正.
（系统说有错的）公式：
=IF(B2=1,"4",IF(B2=2,"4",IF(B2=3,"3",IF(B2=4,"3",IF(B2=5,"3",IF(B2=6,"4",IF(B2=7,"5",IF(B2=8,"5",IF(B2=9,"5",IF(B2=10,"5",IF(B2=11,"4",IF(B2=12,"3","2"))))))))))))
是在excel表格中

Answer 1

语法没错,值得注意的是,旧版本excel（如2003）,有7重的限制,多了就报错.
在excel2010下,这个被扩大到了64重.所以,我这里是ok的.