Home |
Search |
Today's Posts |
#1
|
|||
|
|||
dependent dropdown
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. |
#2
|
|||
|
|||
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. -- Cheers JulieD check out www.hcts.net.au/tipsandtricks.htm ....well i'm working on it anyway "Balder" wrote in message ... 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. |
#3
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Number of dropdown fields in Excel is limited. I need more. How? | Excel Discussion (Misc queries) | |||
Dropdown lists | Excel Discussion (Misc queries) | |||
how to increase the font size in a dropdown list? | Excel Worksheet Functions | |||
dropdown value from range in other sheet | Excel Worksheet Functions | |||
how to make dropdown arrow disappear in vba | Excel Worksheet Functions |