dependent dropdown

B

Balder

first of all, thanks for the super-quick reply at my previous post.

now, i need to do something like this: depending on the value from cell A1
and on the value from cell B1(which is from a dropdown list), i need to
automatically get the appropriate value in cell C1, which is also a dropdown
list. To say it in English: cell A1 is gross income, cell B1 is number of
children i support at home (underaged) and cell C1 should be the deduction
from the taxes i pay for my gross income for supporting those children. For
different ranges of the gross income and the number of kids (both variables
at the same time) i get a exact deduction.

hoping that someone can help me. a solution is very appreciated.
 
J

JulieD

Hi Balder

where in excel are you storing the matrix (or table) that has number of kids
& gross income details? ...
or what is the relationship in terms of a formula as to this relationship

as far as i can see C1 should not be a drop down it should be either an
index/match formula or a mathematical formula to determine the deductions
based on the inputs of A1 & B1.
 
B

Balder

Thanks for your reply. I have all the values stored in the workbook:
1.income - i type it in in cell A1
2. kids - i have them stored in a Data Validation list (no of kids
ranges from 0 - 4, everything above 4 is treated as 4)
3. about deductions, i have them stored in the same workbook on 5
colums, depending on no of kids.

Let me give you an simple example:
for income > 500 and kids=2, the dedction is 20.
for income > 500 and kids=0, the deduction is 10.
As you can see, the relationship between income and kids, on one hand and
deduction is like this: the higher the income the lower the deduction, based
on how many kids you have at home.

Anyways, thanns again for your help.
 
Top