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