Being in Canada, when dealing with cash (not credit/debit cards or cheques), amounts now have to be rounded to the closest nickel, since pennies (officially) are not in circulation any longer.
I'm wondering if there's an easy way to do this using Calc.. I know, using Calc isn't the best for business purposes, but for this I think it'll work fine.
Basically if the amount is between .01 or .02, it gets rounded down to the 0, so $1.92 becomes $1.90
If it's .03 or .04, then it gets rounded up to the .05, so $1.93 becomes $1.95
Likewise with .06 & .07 rounding down, and finally .08 & .09 round up.
It's easy enough to determine the value of the last digit, using
where A1 contains the starting amount.
A simple (though compound) IF can return the 5 or 0 amounts.
Where I've run into a stumbling block, is changing the last digit in A1 to match the value in C1, so that the amount in D1 is the cash amount correctly rounded per the instructions from Canada Revenue.
OpenOffice 4.1.7, LibreOffice 7.0.1.2 on Windows 7 Pro, Ultimate & Windows 10 Home (2004)
If you believe your problem has been resolved, please go to your first post in this topic, click the Edit button and add [Solved] to the beginning of the Subject line.
