Forum Discussion
Multiple conditional if
If that's the only error please remove apostrophes here
=IF(V11<15000/12,0,
IF(V11<30000/12, "(V10-(15000/12))*2.5%",
IF(V11<45000/12, "((V10-(30000/12))*10%)+(375/12)",
IF(V11<60000/12, ((V11-(45000/12))*15%)+(1875/12),
IF(V11<200000/12, ((V11-(60000/12))*20%)+(4125/12),
IF(V11<400000/12, ((V11-(200000/12))*22.5%)+(32125/12),
IF(V11<600000/12, "((V10-(400000/12))*25%)+(77125/12)",
IF(V11<700000/12, "((V10-(400000/12))*25%)+(77500/12)",
IF(V11<800000/12, ((V11-(400000/12))*25%)+(79750/12),
IF(V11<900000/12, ((V11-(400000/12))*25%)+(82000/12),
IF(V11<1000000/12,((V11-(400000/12))*25%)+(85000/12),
IF(V11>1000000/12,((V11-(400000/12))*25%)+(90000/12),0
))))))))))))
I hope you see how much it helps too when you give examples of what IS happening rather than just saying "it doesn't work." There are so very many things that fit the "it doesn't work" description, that it's far better to tell what actually happens and why that's unacceptable.
In fact, the IF function was working for you some of the time, not always; that in itself is VERY useful information, because then we can start looking for "what's distinctive about the times when it IS working compared with when it isn't?"
I used to teach problem solving; one of the basic skills was to describe symptoms precisely, and part of that included noting instances when/where it did work as contrasted when/where it didn't. If it never worked, then there's a legitimate question about what's basically wrong; why should we ever have expected it to work, etc. You were saying that "IF" function wasn't working, but as you can see now, that really was inaccurate.
