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.

In more recent versions of Excel:
and older versions:
where cell D7 is the result of your calculations, or the calculation itself instead of a cell reference.

Thank you p45Cal. It is perfect. I need to do some reading on the role of the .02

How much are taxes? 2% or 20%?

About CEILING() parameter - the result is rounded up, so it will be ending as multiply of parameter. So with parameter = 0.02, the results will be either ?.00, ?.02, ?.04, etc.

Thank you on this. I did some reading on the parameters and got an appreciation of the CEILING function.