The round function is not suitable for financial rounding, apparently. Why is that?

Because if you use rounding in financials, your accountant will never talk to you again! 

Use integers to calculate in terms of your smallest denomination (pence, cents, whatever), format the results to look like real money (pounds.pence, dollars.cents, whatever). (Bob Clark)


That doesn't sound right - if I calculate loan payments in terms of cents, then
that means that one can lose nearly whole cents - if the payment would
have come to $1001.01999 (or in other words 100101.999 cents) by using floats,
by using [integer]s, I end up with $1001.01 - but the bank is very likely
going to be expecting me to pay $1001.02 ...




----
[[Category Function]], a part of [expr] |
[Category Mathematics]