=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
Avinash
(lecturer)
(41 Points)
Replied 15 May 2018
=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
danielle
(student)
(22 Points)
Replied 05 February 2021
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.