|
最近帮朋友做了一个excel的函数,但是输进去以后说“输入的公式中包含错误”,请大家帮我看看哪里错了~?
=IF((B3+C3-1000)<=0,0,IF((B3+C3-1000)<=475,(B3+C3-1000)/(1-0.05),IF((B3+C3-1000)<=1825,(B3+C3-1000-25)/(1-0.1),IF((B3+C3-1000)<=4375,(B3+C3-1000-125)/(1-0.15),IF((B3+C3-1000)<=16375,(B3+C3-1000-375)/(1-0.2),IF((B3+C3-1000)<=31375,(B3+C3-1000-1375)/(1-0.25),IF((B3+C3-1000)<=45375,(B3+C3-1000-3375)/(1-0.3),IF((B3+C3-1000)<=58375,(B3+C3-1000-6375)/(1-0.35),IF((B3+C3-1000)<=70375,(B3+C3-1000-10375)/(1-0.4),(B3+C3-1000-15375)/(1-0.45)))))))))) |
|