Multiple Condition Formula

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