i think your formula will work if you modify it as follows:

=IF(A1>=472.3,(A1-318.3)*0.15,(A1-241.3)*0.1)

where A1 contains your gross wage number. alternatively you might try this formula instead:

=IF(AND(A1>0,A1<=472.29),(A1-241.3)*0.1,0)+IF(AND(A1>472.3,A1<=1124.29),(A1-318.3)*0.15)

also, i wasn't seeing these numbers that you quoted in your post in the new 2003 pub. 15A so I would just double-check your numbers. and you may want to consider using cell references instead of constants in your formula or formulas as these numbers used in the IRS's withholding calculation tables will change often in the future

hth

kevin

## Like this thread? Share it with others