Hi. We collect real property taxes at 2% of the assessed values. Discounts are given to early payors and penalties imposed on the late ones. The collections are shared equally by the local govt and the schools.
To make the sharing seamless, we would like the amounts collected rounded up to the last 2 even decimals.
Example: 21.94*.20=4.39
I would like help in the formula =ROUND(D7*.2,2) that would make it 4.40 and all results to be rounded up to even numbers.
Actually the formulae we are applying to compute the fines and penalties are quite lengthy,I just presented a simplified one here.
Thank you.