I would do it like this:Formula:
=MIN(15000,A1*30%)+MAX(0,MIN(228000,(A1-50000)*24%))+MAX(0,(A1-1000000)*14.4%)
I would do it like this:Formula:
=MIN(15000,A1*30%)+MAX(0,MIN(228000,(A1-50000)*24%))+MAX(0,(A1-1000000)*14.4%)
Please add reputation by clicking on the * if I have helped.
Please mark the thread SOLVED if your issue has been resolved.
Thanks, Glenn.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks