Before I start, A very thoughtful THANK YOU to Ken Write for your help in translating numbers to text. It worked great.
my next problem is a little more involved. on sheet 1 I have a payroll spreadsheet that list the names, hours and tax break downs of all the employees. Most of the tax breakdowns are simple multiplications. =sum(B3*0.0145) But the State and Federal tax forms (that I do have on sheets 2 and 3) are very complicated. (example)
A B C D E &
4 Atleast But less than 0 1 2 3
5 $100 $105 $12.84 $7.84 $7.84 $7.84
6 $105 $110 $14.22 $8.22 $8.22 $8.22
The "At least" is in Column A, The "But less than" is in Column B and the (dependants) 0 through 3 are in Columns C through F. My question is if you have a total amount say on sheet D5 and total amount of dependence in E6. How can you get E7 to find that amount on sheet 2 that would come between the "At least" and "But less than" columns? Example; if the amount was $106.95 and they claimed 2 dependence it would have to located Column E and row 6 in the example above to get $8.22. Does anyone have an idea of how to accomplish this?
Pappykahn
my next problem is a little more involved. on sheet 1 I have a payroll spreadsheet that list the names, hours and tax break downs of all the employees. Most of the tax breakdowns are simple multiplications. =sum(B3*0.0145) But the State and Federal tax forms (that I do have on sheets 2 and 3) are very complicated. (example)
A B C D E &
4 Atleast But less than 0 1 2 3
5 $100 $105 $12.84 $7.84 $7.84 $7.84
6 $105 $110 $14.22 $8.22 $8.22 $8.22
The "At least" is in Column A, The "But less than" is in Column B and the (dependants) 0 through 3 are in Columns C through F. My question is if you have a total amount say on sheet D5 and total amount of dependence in E6. How can you get E7 to find that amount on sheet 2 that would come between the "At least" and "But less than" columns? Example; if the amount was $106.95 and they claimed 2 dependence it would have to located Column E and row 6 in the example above to get $8.22. Does anyone have an idea of how to accomplish this?
Pappykahn
