Hi:
I'm looking for a VLOOKUP or any other kind of formula that would give me either 0%, 50%, or 85% depending on a couple of criterias, Status and Income.
An example of the logic for a person whose status is "Single" and "Income" level is say, $95000.00 is as follows:
If Single AND Income less than $25000, then 0%
If Single AND Income is between $25000 and $34000, then 50%
If Single AND Income is greater than $34000, then 85%
Since this person's is "Single" and his/her Income is $95000, I'd like to be able to get 85%. But this person could be "MFJ" and Income could be between $32000 and $44000. In this case the result should be 50%
Here is an image:
Please see the attached Spreadsheet.
Thanks and much appreciation for your expert assistance.
I'm looking for a VLOOKUP or any other kind of formula that would give me either 0%, 50%, or 85% depending on a couple of criterias, Status and Income.
An example of the logic for a person whose status is "Single" and "Income" level is say, $95000.00 is as follows:
If Single AND Income less than $25000, then 0%
If Single AND Income is between $25000 and $34000, then 50%
If Single AND Income is greater than $34000, then 85%
Since this person's is "Single" and his/her Income is $95000, I'd like to be able to get 85%. But this person could be "MFJ" and Income could be between $32000 and $44000. In this case the result should be 50%
Here is an image:
Please see the attached Spreadsheet.
Thanks and much appreciation for your expert assistance.