PAYE EXCEL VBA CODE NEEDED

[profowo]

Hello House,I need your help for the BVA code for the paye for the form.I am still learning BVA Excel Code.Thanks

Book1
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R
2	Basic	Housing	Transport	LUNCH	Total Income	Pension	NHF	Gross Income	CRA	Chargeable Income	1ST	2ND	3RD	4TH	5TH	6TH	Tax Payable	Monthly Tax
3	37,000.00	27,000.00	25,000.00	22,000.00	1,332,000.00	85,440.00	11,100.00	1,235,460.00	447,092.00	788,368.00	21,000.00	33,000.00	28,255.20	-	-	-	82,255.20	6,854.60
4
5
6
7
Sheet2

Cell Formulas
Range	Formula
E3	E3	=(SUM(A3:D3))*12
F3	F3	=(SUM(A3:C3)*8%)*12
G3	G3	=(A3*2.5%)*12
H3	H3	=E3-F3-G3
I3	I3	=IF(1%*H3>200000,(1%*H3)+20%*H3,200000+(20%*H3))
J3	J3	=E3-F3-G3-I3
K3	K3	=IF(788368<300000,1%*788368,7%*300000)
L3	L3	=IF(788368-300000>=300000, 11%*300000,IF(788368-300000<0,"-",11%*(788368-300000)))
M3	M3	=IF(788368-600000>=500000, 15%*500000,IF(788368-600000<0,"-",15%*(788368-600000)))
N3	N3	=IF(788368-1100000>=500000, 19%*500000,IF(788368-1100000<0,"-",19%*(788368-1100000)))
O3	O3	=IF(788368-1600000>=1600000, 21%*1600000,IF(788368-1600000<0,"-",21%*(788368-1600000)))
P3	P3	=IF(788368-3200000>0,24%*(788368-3200000),"-")
Q3	Q3	=SUM(K3:P3)
R3	R3	=Q3/12