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. |
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. |
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. |
All times are GMT +1. The time now is 12:24 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com