Excel formula

10403 views 16 replies

=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

Replies (16)

=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.   


CCI Pro

Leave a Reply

Your are not logged in . Please login to post replies

Click here to Login / Register