If statement with conditions

[Thomas2017]

Hello,

I'm trying to do an IF statement formula but I have too many arguments. My goal is to assign a numeric value in cell C3 based on conditions met or not met in C2 and C1. For example, as shown if table below --- if income is between $24,600 - $49,200 and the family size is 4 or fewer, then the payment is 20%. I want this 20% to be calculated automatically. If I put in 35,000 in C1 and 3 Family members in C2, I want C3 to automatically produce a value of 20%

Family Size	Pay Nominal Fee ($5)	Pay 20%	Pay 40%	Pay 60%	Pay 80%	Pay 100%
4 or fewer	$24,600	$49,200	$98,400	$147,600	$196,800	$196,801
5	$28,780	$57,560	$115,120	$172,680	$230,240	$230,241
6	$32,960	$65,920	$131,840	$197,760	$263,680	$263,681
7	$37,140	$74,280	$148,560	$222,840	$297,120	$297,121
For each additional person, add	$4,180	$5,225	$6,270	$7,315	$7,315

<tbody>
</tbody>

 

[oldbrewer]

Family Size	Pay Nominal Fee ($5)	Pay 20%	Pay 40%	Pay 60%	Pay 80%	Pay 100%
2	24600	2	4	6	8	8
3	24600	2	4	6	8	8
4	24600	2	4	6	8	8
5	28780	2	4	6	8	8
6	32960	2	4	6	8	8
7	37140	2	4	6	8	8
8	42365	2	4	6	8	8
9	47590	2	4	6	8	8
10	52815	2	4	6	8	8		mytable
11	58040	2	4	6	8	8
12	63265	2	4	6	8	8
13	68490	2	4	6	8	8		0	5
14	73715	2	4	6	8	8		1	2
15	78940	2	4	6	8	8		2	2
								3	4
								4	4
								5	6
								6	6
								7	8
								8	8
		family1	4	31000	49200	******
		family2	7	38000	74280
		family3	9	45000	237950
		family4	5	52000	57560
		family5	6	59000	65920
		family6	8	66000	84730
		family7	15	73000	394700
		family8	13	80000	136980
		family9	10	87000	105630
		family10	11	94000	116080
			******
	=(VLOOKUP(INT(E30/OFFSET($A$2,MATCH($D30,$A$3:$A$16,0),1)),mytable,2))*OFFSET($A$2,MATCH($D30,$A$3:$A$16,0),1)

<colgroup><col><col><col><col><col><col><col><col span="4"></colgroup><tbody>
</tbody>

 

[Thomas2017]

Thank you so much for replying to my inquiry. I'm not sure if I understand how to do this exactly in excel. This doesn't show any ranges or if it does, I don't see them. I would love any additional advice you could give me.

 

[oldbrewer]

$a$3:$a$16 is a range

I found the family size then divided income by first amount and used that integer amount in the look up table (mytable)