🔮R5源泉徴収税額表

	A	B	C	D	E	F	G	H	I	J	K	L	N	O	P
1		給与所得の源泉徴収税額表（令和５年分）
2		月　額　表（平成24年３月31日財務省告示第115号別表第一（令和２年３月31日財務省告示第81号改正））
3		その月の社会保		甲									金額	160,000
4		険料等控除後の		扶養親族等の数								乙	人数	1
5		給与等の金額		0	1	2	3	4	5	6	7		税額	1,720	←XLOOKUP関数
6		以上	未満	税額								税額
7		円	円	円	円	円	円	円	円	円	円	円
8		0	円未満	0	0	0	0	0	0	0	0	その月の社会保険料等控除後の給与等の金額の3.063％に相当する金額
9
10	1	88,000	89,000	130	0	0	0	0	0	0	0	3,200
11	2	89,000	90,000	180	0	0	0	0	0	0	0	3,200
12	3	90,000	91,000	230	0	0	0	0	0	0	0	3,200
13	4	91,000	92,000	290	0	0	0	0	0	0	0	3,200
14	5	92,000	93,000	340	0	0	0	0	0	0	0	3,300
15
16	6	93,000	94,000	390	0	0	0	0	0	0	0	3,300
17	7	94,000	95,000	440	0	0	0	0	0	0	0	3,300
18	8	95,000	96,000	490	0	0	0	0	0	0	0	3,400
19	9	96,000	97,000	540	0	0	0	0	0	0	0	3,400
20	10	97,000	98,000	590	0	0	0	0	0	0	0	3,500
21
22	11	98,000	99,000	640	0	0	0	0	0	0	0	3,500
23	12	99,000	101,000	720	0	0	0	0	0	0	0	3,600
24	13	101,000	103,000	830	0	0	0	0	0	0	0	3,600
25	14	103,000	105,000	930	0	0	0	0	0	0	0	3,700
26	15	105,000	107,000	1,030	0	0	0	0	0	0	0	3,800
27
28	16	107,000	109,000	1,130	0	0	0	0	0	0	0	3,800
29	17	109,000	111,000	1,240	0	0	0	0	0	0	0	3,900
30	18	111,000	113,000	1,340	0	0	0	0	0	0	0	4,000
31	19	113,000	115,000	1,440	0	0	0	0	0	0	0	4,100
32	20	115,000	117,000	1,540	0	0	0	0	0	0	0	4,100
33
34	21	117,000	119,000	1,640	0	0	0	0	0	0	0	4,200
35	22	119,000	121,000	1,750	120	0	0	0	0	0	0	4,300
36	23	121,000	123,000	1,850	220	0	0	0	0	0	0	4,500
37	24	123,000	125,000	1,950	330	0	0	0	0	0	0	4,800
38	25	125,000	127,000	2,050	430	0	0	0	0	0	0	5,100
39
40	26	127,000	129,000	2,150	530	0	0	0	0	0	0	5,400
41	27	129,000	131,000	2,260	630	0	0	0	0	0	0	5,700
42	28	131,000	133,000	2,360	740	0	0	0	0	0	0	6,000
43	29	133,000	135,000	2,460	840	0	0	0	0	0	0	6,300
44	30	135,000	137,000	2,550	930	0	0	0	0	0	0	6,600
45
46	31	137,000	139,000	2,610	990	0	0	0	0	0	0	6,800
47	32	139,000	141,000	2,680	1,050	0	0	0	0	0	0	7,100
48	33	141,000	143,000	2,740	1,110	0	0	0	0	0	0	7,500
49	34	143,000	145,000	2,800	1,170	0	0	0	0	0	0	7,800
50	35	145,000	147,000	2,860	1,240	0	0	0	0	0	0	8,100
51
52	36	147,000	149,000	2,920	1,300	0	0	0	0	0	0	8,400
53	37	149,000	151,000	2,980	1,360	0	0	0	0	0	0	8,700
54	38	151,000	153,000	3,050	1,430	0	0	0	0	0	0	9,000
55	39	153,000	155,000	3,120	1,500	0	0	0	0	0	0	9,300
56	40	155,000	157,000	3,200	1,570	0	0	0	0	0	0	9,600
57
58	41	157,000	159,000	3,270	1,640	0	0	0	0	0	0	9,900
59	42	159,000	161,000	3,340	1,720	100	0	0	0	0	0	10,200
60	43	161,000	163,000	3,410	1,790	170	0	0	0	0	0	10,500
61	44	163,000	165,000	3,480	1,860	250	0	0	0	0	0	10,800
62	45	165,000	167,000	3,550	1,930	320	0	0	0	0	0	11,100
63
64	46	167,000	169,000	3,620	2,000	390	0	0	0	0	0	11,400
65	47	169,000	171,000	3,700	2,070	460	0	0	0	0	0	11,700
66	48	171,000	173,000	3,770	2,140	530	0	0	0	0	0	12,000
67	49	173,000	175,000	3,840	2,220	600	0	0	0	0	0	12,400
68	50	175,000	177,000	3,910	2,290	670	0	0	0	0	0	12,700
69
70	51	177,000	179,000	3,980	2,360	750	0	0	0	0	0	13,200
71	52	179,000	181,000	4,050	2,430	820	0	0	0	0	0	13,900
72	53	181,000	183,000	4,120	2,500	890	0	0	0	0	0	14,600
73	54	183,000	185,000	4,200	2,570	960	0	0	0	0	0	15,300
74	55	185,000	187,000	4,270	2,640	1,030	0	0	0	0	0	16,000
75
76	56	187,000	189,000	4,340	2,720	1,100	0	0	0	0	0	16,700
77	57	189,000	191,000	4,410	2,790	1,170	0	0	0	0	0	17,500
78	58	191,000	193,000	4,480	2,860	1,250	0	0	0	0	0	18,100
79	59	193,000	195,000	4,550	2,930	1,320	0	0	0	0	0	18,800
80	60	195,000	197,000	4,630	3,000	1,390	0	0	0	0	0	19,500
81
82	61	197,000	199,000	4,700	3,070	1,460	0	0	0	0	0	20,200
83	62	199,000	201,000	4,770	3,140	1,530	0	0	0	0	0	20,900
84	63	201,000	203,000	4,840	3,220	1,600	0	0	0	0	0	21,500
85	64	203,000	205,000	4,910	3,290	1,670	0	0	0	0	0	22,200
86	65	205,000	207,000	4,980	3,360	1,750	130	0	0	0	0	22,700
87
88	66	207,000	209,000	5,050	3,430	1,820	200	0	0	0	0	23,300
89	67	209,000	211,000	5,130	3,500	1,890	280	0	0	0	0	23,900
90	68	211,000	213,000	5,200	3,570	1,960	350	0	0	0	0	24,400
91	69	213,000	215,000	5,270	3,640	2,030	420	0	0	0	0	25,000
92	70	215,000	217,000	5,340	3,720	2,100	490	0	0	0	0	25,500
93
94	71	217,000	219,000	5,410	3,790	2,170	560	0	0	0	0	26,100
95	72	219,000	221,000	5,480	3,860	2,250	630	0	0	0	0	26,800
96	73	221,000	224,000	5,560	3,950	2,340	710	0	0	0	0	27,400
97	74	224,000	227,000	5,680	4,060	2,440	830	0	0	0	0	28,400
98	75	227,000	230,000	5,780	4,170	2,550	930	0	0	0	0	29,300
99
100	76	230,000	233,000	5,890	4,280	2,650	1,040	0	0	0	0	30,300