[已解决]麻烦帮我看看公式哪里不对了，谢谢！！

yvhanym · 发表于 2010-4-6 10:21

10级及以上：20分

8-9级：14分

6-7级：10分

4-5级：8分

1-3级：6分

=IF(1<=H5<=3,6,IF(4<=H5<=5,8,IF(6<=H5<=7,10,IF(8<=H5<=9,14,IF(10<=H5,20,0)))))

公式哪里不对了啊

要不谁给个正确的公式啊

最佳答案

maodaojin6

2010-4-6 10:28

=IF(AND(1<=H5,H5<=3),6,IF(AND(4<=H5,H5<=5),8,IF(AND(6<=H5,H5<=7),10,IF(AND(8<=H5,H5<=9),14,IF(10<=H5,20,0)))))

maodaojin6 · 发表于 2010-4-6 10:26

maodaojin6 · 发表于 2010-4-6 10:28

=IF(AND(1<=H5,H5<=3),6,IF(AND(4<=H5,H5<=5),8,IF(AND(6<=H5,H5<=7),10,IF(AND(8<=H5,H5<=9),14,IF(10<=H5,20,0)))))

wyg791019 · 发表于 2010-4-6 10:29

1<=H5<=3 这样的条件不能这样写，应该写成and(h5<=3,h5=>1)

紫猪侠 · 发表于 2010-4-6 10:30

=LOOKUP(A1,{1,6;4,8;6,10;8,14;10,20})

我心永恒 · 发表于 2010-4-6 10:51

[em01]

rsjys · 发表于 2010-4-6 11:04

IF(H5<=3,6,IF(H5<=5,8,IF(H5<=7,10,IF(H5<=9,14,20))))

yl0205 · 发表于 2010-4-6 11:46

IF(H5<=3,6,IF(H5<=5,8,IF(H5<=7,10,IF(H5<=9,14,20))))

		自动登录	找回密码
密码			注册