Excel formula

=IF(L44<500000,IF(L45<=5000,L45,IF(L45>5001,5000,)),0)

enjoy L44 taxable income and L45 is tax

in case query call or email

Thank you very much for sharing this formula. It came in handy for me on the exam. I usually buy homework by excel so it can be difficult for me to write tests. By the way, for students who also want to buy homework by excel, i have a recommendation.