Thomas2017
New Member
- Joined
- Mar 31, 2017
- Messages
- 8
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%
<tbody>
</tbody>
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>