比如我有一列百分数,100%,95%,95.6%这样,我希望在100%的时候等于10,每少1%就减0.5。到80%及以下的时候变成0。函数应该怎么写啊。
写了一个这样的if函数只能正常显示100,其他数值都显示95
=IF(M7=100%,“10”,IF(100>M7>=99%,“9.5”,
IF(99%>M7>=98%,“9”,
IF(98%>M7>=97%,“8.5”,
IF(97%>M7>=96%,“8”,
IF(96%>M7>=95%,“7.5”,
IF(95%>M7>=94%,“7”,
IF(94%>M7>=93%,“6.5”,
IF(93%>M7>=92%,“6”,
IF(92%>M7>=91%,“5.5”,
IF(91%>M7>=90%,“5”,
IF(90%>M7>=89%,“4.5”,
IF(89%>M7>=88%,“4”,
IF(88%>M7>=87%,“3.5”,
IF(87%>M7>=86%,“3”,
IF(86%>M7>=85%,“2.5”,
IF(85%>M7>=84%,“2”,
IF(84%>M7>=83%,“1.5”,
IF(83%>M7>=82%,“1”,
IF(82%>M7>=81%,“0.5”,
IF(81%>M7<=80%,“0”,)))))))))))))))))))))