profowo
New Member
- Joined
- Jul 27, 2023
- Messages
- 3
- Office Version
- 2016
- 2013
- 2011
- 2010
- 2007
- 2003 or older
- Platform
- Windows
- Mobile
- Web
Please I want to merge all the calculation in each cells to one cell and Get the BVA Excel CODE to give me the value of PAYE when input the taxable Income
TAX 2.xlsx | |||||
---|---|---|---|---|---|
D | E | F | |||
2 | TAXABLE INCOME | 788,368.00 | 21,000.00 | ||
3 | 33,000.00 | ||||
4 | 28,255.20 | ||||
5 | - | ||||
6 | - | ||||
7 | - | ||||
8 | ANNUAL PAYE | 82,255.20 | |||
9 | PAYE | 6,854.60 | |||
Sheet1 |
Cell Formulas | ||
---|---|---|
Range | Formula | |
F2 | F2 | =IF(E2<300000,0.07*E2,0.07*300000) |
F3 | F3 | =IF(E2-300000>=300000, 0.11*300000,IF(E2-300000<0,"-",0.11*(E2-300000))) |
F4 | F4 | =IF(E2-600000>=500000, 0.15*500000,IF(E2-600000<0,"-",0.15*(E2-600000))) |
F5 | F5 | =IF(E2-1100000>=500000, 0.19*500000,IF(E2-1100000<0,"-",0.19*(E2-1100000))) |
F6 | F6 | =IF(E2-1600000>=1600000, 21%*1600000,IF(E2-1600000<0,"-",21%*(E2-1600000))) |
F7 | F7 | =IF(E2-3200000>0,24%*(E2-3200000),"-") |
F8 | F8 | =SUM(F2:F7) |
F9 | F9 | =F8/12 |