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
))))))))))))
Thank you for your reply, but i still do not have any idea what i have to do 😞
What SergeiBaklan is telling you here, and what I tried to tell you on your other post with this same nested IF question is this:
When you say a formula "doesn't work" you may be very clear in your own mind what it means. BUT it doesn't say what DOES happen? Doesn't work is saying what does not happen, not what does.
- So is it an error message you get? If so, what's the error message?
- Does the formula just not give an answer at all? Does it hang there without any result?
- Does the formula give you an answer but one you don't expect?
WHAT DOES HAPPEN?
SergeiBaklan has been far nicer than I in that he parsed the formula to see if the syntax was acceptable, and it appeared to be. Excel probably wouldn't have let you finish writing it had it not been.
Anyway, if you really want an answer, you're going to have to answer our questions for you.
Sorry for sending the same problem twice it is my first time here, and thanks for your efforts.
Here are a screenshot for when it works and when it not.
for that, i can not find out the problem, also i do not have "IFS" equation in my version so i can not use it, is there another equation?
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
))))))))))))
