View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
joeu2004 joeu2004 is offline
external usenet poster
 
Posts: 2,059
Default Formula in a cell to calc FUTA tax

Improvement....

On Nov 15, 7:46 pm, I wrote:
For FUTA Per Period:
=round(0.8%*min(n(A2), max(0, 7000-A1+A2)), 2)
[....]
The above formulas can result in an off-by-some-pennies
error due to periodic rounding.


I think the following avoids that problem, albeit more complicated:

=min(round(A2*0.8%, 2), max(0, 56-round((A1-A2)*0.8%, 2)))