Excellent!
It's fast (the function in last post) and works when you take the following into consideration:
There seems to be a problem with the CDbl or using a double variable, as mentioned in thread356567.
RoundF(4.989195 ,5) rounds to 4.98919 and not 4.98920.
The only thing that seems to work is to use Singles/CSng, Currency/CCur or CDec, the last 2 being most accurate with-in their the ranges you mentioned, and the Single being also good but cannot use with extremely small/large numbers.
The only answer there seems to be is to use a Single variable or the CSng functions, or, if the number is small enough, then use CCur or a currency variable, or the CDec function.
However, the request is for financial rounding. So, the number of digits should not be that much, and, if it is a financial class or proceedure or even application, then it would seem fitting to always use Currency variables for currency figures.
In the case of rounding non-currency values, I think the use of a Single is good enough for rounding. If you are working with very small numbers, then you have no choice but to use a Double.
