Multiple Condition Formula

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

Hi
If the numbers in the first column ( A1) and the the incomes (B1) are
directly related, you would simply add another column (C1). In C1 put
=B1*0.40 and copy down as far as required.


HTH
Michael

"prolixity" wrote:

> 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

Ok. I must not have explained my question properly. I apologize.

Here is the set up of my spreadsheet:

Unit Percentage # in Household Maximum Income
41% 2
39% 5

"Michael" wrote:

> Hi
> If the numbers in the first column ( A1) and the the incomes (B1) are
> directly related, you would simply add another column (C1). In C1 put
> =B1*0.40 and copy down as far as required.
>
>
> HTH
> Michael
>
> "prolixity" wrote:
>
> > 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

Ok. I must not have properly explained my question. I apologize.

Here an excerpt from my spreadsheet:

Assigned % # in Household 140% of Income
41% 2 =49100*.41*1.4
38% 3 =55200*.38*1.4
67% 1 =42900*.67*1.4
etc.

(I am still referencing the data that I listed in my original post.)

So, how do I get the "140% of Income" column to automatically take the
income amount (e.g. 42900) assigned to the number in the household to use in
the formula without having to manually do it?

Does this make sense?

"Michael" wrote:

> Hi
> If the numbers in the first column ( A1) and the the incomes (B1) are
> directly related, you would simply add another column (C1). In C1 put
> =B1*0.40 and copy down as far as required.
>
>
> HTH
> Michael
>
> "prolixity" wrote:
>
> > 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

SORRY! This is my first time posting here...

In my last post I am assuming the following:

# in Household Income
1 42,900
2 49,100
3 55,200

"prolixity" wrote:

> Ok. I must not have properly explained my question. I apologize.
>
> Here an excerpt from my spreadsheet:
>
> Assigned % # in Household 140% of Income
> 41% 2 =49100*.41*1.4
> 38% 3 =55200*.38*1.4
> 67% 1 =42900*.67*1.4
> etc.
>
> (I am still referencing the data that I listed in my original post.)
>
> So, how do I get the "140% of Income" column to automatically take the
> income amount (e.g. 42900) assigned to the number in the household to use in
> the formula without having to manually do it?
>
> Does this make sense?
>
> "Michael" wrote:
>
> > Hi
> > If the numbers in the first column ( A1) and the the incomes (B1) are
> > directly related, you would simply add another column (C1). In C1 put
> > =B1*0.40 and copy down as far as required.
> >
> >
> > HTH
> > Michael
> >
> > "prolixity" wrote:
> >
> > > 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

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