Calculating as supplement based on a years of service

[Amandac6772]

Hello,
I need to calculate a % supplement based on the number of years of service. I've tried IF formulas but they don't work. Below is a snip-it of my spreadsheet. Is there a simple formula for this?

 

[alansidman]

Change up your lookup table as shown below and then use vlookup

Book3
	B	C	D	E	F	G	H	I	J	K
1	FirstName	YearsOfService	PayAmount	Salary	Supplement				Years of Service
2	ASHLEY	2	5228	52280	1045.6				0	2.00%
3	KRISTY	14	6027	60270	1808.1				5	2.50%
4	BRITTANY	8	4753	47530	1188.25				10	3.00%
5	CAITLIN	4	4400	44000	880				15	3.50%
6	TIMOTHY	12	6553	78636	2359.08				20	4.00%
7	BRIAN	6	4475	44750	1118.75				25	4.50%
8	JAMES	25	5595	55950	2517.75
9	LISA	16	5941	71292	2495.22
10	SHERA	27	6155	61550	2769.75
11	TAYLOR	5	4475	44750	1118.75
12	JILLIAN	6	5429	54290	1357.25
13	KATELYN	4	4325	43250	865
14	WILLIAM	1	5968	59680	1193.6
Sheet1

Cell Formulas
Range	Formula
F2:F14	F2	=VLOOKUP(C2,$J$2:$K$7,2,TRUE)*E2

 

[Dave Patton]

What results do you expect?
N.B. You can post an extract of your sheet to the forum; the tool is named XL2BB.

Try a Lookup.
Possibly

T202502a.xlsm
	A	B	C	D	E
1
2	Name	Years	Payout	Salary	Supplement
3	Ashley	2	5,228.00	52,280.00	104.56
1f

Cell Formulas
Range	Formula
E3	E3	=C3*LOOKUP(B3,J2:K7)

 

[Amandac6772]

Change up your lookup table as shown below and then use vlookup

Book3
	B	C	D	E	F	G	H	I	J	K
1	FirstName	YearsOfService	PayAmount	Salary	Supplement				Years of Service
2	ASHLEY	2	5228	52280	1045.6				0	2.00%
3	KRISTY	14	6027	60270	1808.1				5	2.50%
4	BRITTANY	8	4753	47530	1188.25				10	3.00%
5	CAITLIN	4	4400	44000	880				15	3.50%
6	TIMOTHY	12	6553	78636	2359.08				20	4.00%
7	BRIAN	6	4475	44750	1118.75				25	4.50%
8	JAMES	25	5595	55950	2517.75
9	LISA	16	5941	71292	2495.22
10	SHERA	27	6155	61550	2769.75
11	TAYLOR	5	4475	44750	1118.75
12	JILLIAN	6	5429	54290	1357.25
13	KATELYN	4	4325	43250	865
14	WILLIAM	1	5968	59680	1193.6
Sheet1

Cell Formulas
Range	Formula
F2:F14	F2	=VLOOKUP(C2,$J$2:$K$7,2,TRUE)*E2

Thank you. That worked perfectly!