Hello Everyone!

I'll use the following data set to help illustrate my question:

Number In Household Income
1 10,000
2 15,000
3 20,000
etc.

I'm trying to create a formula that will tell me a percentage (for this
example, let's say 40%) of the income assigned to a particular number of
household members. The number in the household can range from 1-8 for any
particular cell and will have a distinct income assigned to it.

So, if the reference cell lists 3 household members I need the cell
containing the formula to calculate 40% of 20,000. However, the reference
cell could be any number between 1 and 8.

Please let me know if I have explained this poorly and you need further
claification. Thank you for your help!!!

prolixity