J
jacob farino
Second issue, I'm hoping this will be the easier of the two:
I have a list of income sources in Column A. I have a total income listed in
Column B. I have a tax-deductible option (currently, drop down list 'YES' or
'NO') in Column C.
I have the income totalled at the bottom.
At the bottom of my sheet, I have a drop-down list for the end-user to
select which investor they are going to send this particular income
calculation sheet to. Depending on which investor they choose, I need to
mark-up the income total by that investor's particular mark-up, and only if
the income source is tax deductible.
For instance, I have three income sources listed. Each are $1000. Two are
tax deductible, one is not. I select an investor, investor X for example,
and I know that investor X allows me to gross up my non-taxable income by
25%. So, the formula would need to figure out that my sub-total income is
$3000. I can gross up $2000 of this ($2000 x 1.25 = $2500), so my TOTAL
income is actually $3500.
And if I select another investor, and their mark-up is 20%, then my new
income would be $3400.
Does this make sense? I'm not sure if drop-down lists are the way to go
here, or if you have an easier way to get what I need.
I'm using XP w/ excel 2002.
Thanks so much
Jacob
I have a list of income sources in Column A. I have a total income listed in
Column B. I have a tax-deductible option (currently, drop down list 'YES' or
'NO') in Column C.
I have the income totalled at the bottom.
At the bottom of my sheet, I have a drop-down list for the end-user to
select which investor they are going to send this particular income
calculation sheet to. Depending on which investor they choose, I need to
mark-up the income total by that investor's particular mark-up, and only if
the income source is tax deductible.
For instance, I have three income sources listed. Each are $1000. Two are
tax deductible, one is not. I select an investor, investor X for example,
and I know that investor X allows me to gross up my non-taxable income by
25%. So, the formula would need to figure out that my sub-total income is
$3000. I can gross up $2000 of this ($2000 x 1.25 = $2500), so my TOTAL
income is actually $3500.
And if I select another investor, and their mark-up is 20%, then my new
income would be $3400.
Does this make sense? I'm not sure if drop-down lists are the way to go
here, or if you have an easier way to get what I need.
I'm using XP w/ excel 2002.
Thanks so much
Jacob