弄了一上午也没弄懂该怎样编这个函数。
看前面一个格里的数，如果<=0.01,那么结果就是0.01,如果<=0.03,大于0.01,那么结果就是0.015;如果大于0.03,小于等于0.06,那么结果就是0.02;如果大于0.06,小于等于0.09,那么结果就是0.025;如果大于9,那么结果就是0.03。我编个公式=IF(P3<=0.01,0.01,IF(P3>0.01,0.015,IF(P3<=0.03,0.015,IF(P3>0.03,0.02,IF(P3<=0.06,0.02,IF(P3>0.06,0.025,IF(P3<=0.09,0.025,IF(P3>0.09,0.03))))))))。可是结果不对，求大神指点
看前面一个格里的数，如果<=0.01,那么结果就是0.01,如果<=0.03,大于0.01,那么结果就是0.015;如果大于0.03,小于等于0.06,那么结果就是0.02;如果大于0.06,小于等于0.09,那么结果就是0.025;如果大于9,那么结果就是0.03。我编个公式=IF(P3<=0.01,0.01,IF(P3>0.01,0.015,IF(P3<=0.03,0.015,IF(P3>0.03,0.02,IF(P3<=0.06,0.02,IF(P3>0.06,0.025,IF(P3<=0.09,0.025,IF(P3>0.09,0.03))))))))。可是结果不对，求大神指点
