i need to make 4 (four) =if(and formula, when i make it one by one, they work, when i combined all those 3, it works, but then i combined all of 4, error:
=IF(AND(C34>0,C34<=50000000),C34*5%,IF(AND(C34>50000000,C34<=250000000),(50000000*5%)+(C34-50000000)*15%,IF(AND(C34>250000000,C34<=500000000),((50000000*5%)+((250000000-50000000)*15%)+((C34-250000000)*25%,IF(AND(C34>500000000),((50000000*5%)+((250000000-50000000)*15%)+(C34-250000000)*25%)+(C34-500000000)*35%))))))
please kindly check my formula
Solved by S. J. in 16 mins