G

#### Guest

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...