Yahoo Answers is shutting down on May 4th, 2021 (Eastern Time) and beginning April 20th, 2021 (Eastern Time) the Yahoo Answers website will be in read-only mode. There will be no changes to other Yahoo properties or services, or your Yahoo account. You can find more information about the Yahoo Answers shutdown and how to download your data on this help page.
Trending News
How do I use the AND function in Excel?
I want to set several different percentages to several ranges of income, BUT the income varies if the situation is for a single person, married person, etc.
This is part of my failed equation, but you might understand my thinking...
=IF(AND(B43="single", D13<33950,"15")).
There may be an easier way, but I dont know it. Please advise!
A little more background.... This spreadsheet is for phone interviews with prospects so their information is typed in, such as "Married", and income of $40K, they fall within the proper tax bracket (25% is set for $33,951 - $68,525)
1 Answer
- CozmosisLv 71 decade agoFavorite Answer
So you have different percentages for single vs married AND different income levels.
I would recommended you make a look-up table on your sheet.
Say J2 to J10 has the max income cut-off levels for each percentage
K1 has "Single"
L1 has "Married"
K2 to L10 has the percentages
B2 indicates the Single/Married status to look-up
D13 is the income level to look-up
=INDEX($K$2:$L$10, MATCH(D13, $J$2:$J$10,1), MATCH(B2, $K$1:$L$1,0))
.
Source(s): INDEX MATCH - Excel Index Function and Excel Match Function http://www.contextures.com/xlFunctions03.html
