I want to create a statement to calculate appropriate federal tax withholding
amounts based on gross income, which varies each pay period. The federal tax
tables specify minimum & maximum salary ranges, a withholding allowance,
multiplier percentages and a fixed withholding amount for each set of
calculations.

For example, a formula for an income figure between $389.00 and $1289.00 in
a pay period would be (assuming the gross income figure is in cell D6):
=((D6-130.77)-389)*.15+28.70

For an income figure between $1289.00 and $2964.00 in a pay period, the
formula would be:
=((D6-130.77)-1289)*.25+163.70

For an income figure between $2964.00 and $6262.00 in a pay period, the
formula would be:
=((D6-130.77)-2964)*.28+582.45

Now...how do I pull these all together into one statment that will look at
the gross income figure in cell D6 and produce the correct withholding figure
in another cell? (I currently use Excel 2000.)

Whew! Thanks...

--
- Clint Johnson