In A1 put "NUMBER IN HOUSEHOLD"
In B1 put "INCOME"
In C1 put "CALCULATION"
Then enter your normal data below in columns A and B

I.n G1 put 1, G2 put2, G3 put 3, G4 put 4, G5 put 5
G6 put 6, G7 put 7, G8 put 8

Then in H1 to H8 put the multiples you wish for each number of people in the
household, such as H1 put .67, H2 put .41, etc etc

Then in C2 put this formula and copy it down as far as you have data in A
and B

=VLOOKUP(A2,$G$1:$H$8,2,FALSE)*B2*1.4


Vaya con Dios,
Chuck, CABGx3



"prolixity" <p
rolixity@discussions.microsoft.com> wrote in message
news:1A547126-3A3F-4028-9AC5-16B3CB9E14EF@microsoft.com...
> 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