Assuming your data above is in cells A1 to B6, you can add these labels
in A8 to A10:

A8: Adjusted Net
A9: Difference
A10: Adjusted Tax

and add these formulae in B8 to B10:

B8: =FLOOR(B6,5)
B9: =B6-B8
B10: =B2+B9

Hope this helps.

Pete

Gerard wrote:
Dave F wrote:
What formula are you currently using?

=FLOOR(x,5)

Rounds the net pay to the nearest (lowest) $5 multiple. But then how
can I re add this to the tax amount and calculate a new net figure?