Hi All
I need help. How to calculate allowance whenever there are various percent based on monthly salary.
12% - 6289 & above
15% - 4029-6288
17.5% - 2015-4028
20% - 1329-2014
22.5% - 1328 & below
If cells A1 4029 and cells B1 estimates continue 15% become 604.35. Cells B1 requires formula automatically calculation give to all percent above.
Bookmarks