IF(C7<=0,0,(IF(C7<=500,0,IF(C7<=2000,25,IF(C7<=5000,125,IF(C7<=20000,375,IF(C7<=40000,1375,IF(C7<=60000,3375,IF(C7<=80000,6375,IF(C7<=100000,10375,15375)))))))))
IF(C7<=0,0,(IF(C7<=500,0.05,IF(C7<=2000,0.1,IF(C7<=5000,0.15,IF(C7<=20000,0.20,IF(C7<=40000,0.25,IF(C7<=60000,0.30,IF(C7<=80000,0.35,IF(C7<=100000,0.4,0.45)))))))))
求大神把这两条公式改一下 (仍保留if函数)谢谢!!
谢谢~那如果仍然用if可以吗?可以的话咋改啊?
追答2003肯定不行 2007以上好像支持超过7层嵌套 道听途说的 没在意过 再说了 超过7层自己太累了 没必要一条胡同走到黑
本回答被网友采纳