View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
joeu2004 joeu2004 is offline
external usenet poster
 
Posts: 2,059
Default Payroll tax deductions

Errata....

On Mar 2, 11:26*am,
wrote:
=round( (D2 - vlookup(D2, choose(C2, Weekly, Biweekly, SemiMonthly, Monthly,
Quarterly, Semiannually, Annually, Daily), 1)


There is a missing right parenthesis. It should be:

=round( (D2 - vlookup(D2, choose(C2, Weekly, Biweekly, SemiMonthly,
Monthly,
Quarterly, Semiannually, Annually, Daily), 1))


Also note that technically, column of the withholding table should be one
less (i.e. 50, 197, 652, etc).


I meant to write: "... column 1 of the withholding table ...".