S
sandors13 \(removethis\)
can i use an imbeded IF clause in another IF statement and
if so which IF is applied first
for example:
i have one yes/no collum (that i will hide) that ask
weather the "$100,000" number is greater then the upper
limit of each range IF YES then upper limit-lower limit*
the tax braket. IF NO then your income-lower limit*the tax
bracket. but where i am having a problem is i cant have it
return a negative #. so i want to reference the yes /no of
the previous line. If previous answer is no then return a
0 for that bracket.
how do i put more then one condition and which will it
read first, i need it to read the above line first then
the original argument.
10% Bracket $0 $7,000 YES 70
15% Bracket $7,001 $28,400 YES 3209.85
25% Bracket $28,401 $68,800 YES 10099.75
28% Bracket $68,801 $143,500 NO 8735.72
33% Bracket $143,501$ 311,950 NO -14355.33
35% Bracket $311,951 and up NO
Your income 100,000
Total Tax Liability 7759.99
sorry so long thanks for any help!
if so which IF is applied first
for example:
i have one yes/no collum (that i will hide) that ask
weather the "$100,000" number is greater then the upper
limit of each range IF YES then upper limit-lower limit*
the tax braket. IF NO then your income-lower limit*the tax
bracket. but where i am having a problem is i cant have it
return a negative #. so i want to reference the yes /no of
the previous line. If previous answer is no then return a
0 for that bracket.
how do i put more then one condition and which will it
read first, i need it to read the above line first then
the original argument.
10% Bracket $0 $7,000 YES 70
15% Bracket $7,001 $28,400 YES 3209.85
25% Bracket $28,401 $68,800 YES 10099.75
28% Bracket $68,801 $143,500 NO 8735.72
33% Bracket $143,501$ 311,950 NO -14355.33
35% Bracket $311,951 and up NO
Your income 100,000
Total Tax Liability 7759.99
sorry so long thanks for any help!