各位大侠，请帮帮忙这个怎么做函数？

chen14033

我怎么设置公式，才能符合如下条件：

提案改善≥1，得6分；提案改善=0，得0分；提案改善=0.5，得6/2 分

chen14033

谢谢
但现在有个最好复杂的,=IF(D11<=3,7,(IF(D11=3,C11-6,IF(D11=4,C11-12,IF(D11=5,C11-18,IF(D11=6,C11-24,IF(D11=7,C11-30,IF(D11>=8,C11-36,0))))))))+IF(E11<=3,7,(IF(E11=6,C11-3,IF(E11=12,C11-6,IF(E11=18,C11-9,IF(E11=24,C11-12,IF(E11=30,C11-15,IF(E11>=8,C11-36,0))))))))+IF(F11<=3,7,(IF(F11=3,C11-6,IF(F11=4,C11-12,IF(F11=5,C11-18,IF(F11=6,C11-24,IF(F11=7,C11-30,IF(F11>=8,C11-36,0))))))))+IF(G11<=3,7,(IF(G11=3,C11-6,IF(G11=4,C11-12,IF(G11=5,C11-18,IF(G11=6,C11-24,IF(G11=7,C11-30,IF(G11>=8,C11-36,0))))))))+IF(H11<=3,7,(IF(H11=3,C11-6,IF(H11=4,C11-12,IF(H11=5,C11-18,IF(H11=6,C11-24,IF(H11=7,C11-30,IF(H11>=8,C11-36,0))))))))+IF(I11<=3,7,(IF(I11=3,C11-6,IF(I11=4,C11-12,IF(I11=5,C11-18,IF(I11=6,C11-24,IF(I11=7,C11-30,IF(I11>=8,C11-36,0))))))))
这个公式,如何让他最后的得数不会成负数,最小就等于0呢

pureshadow

=max(提案改善*6,6)