A question on the limits of Round2(Number, Decimalplaces). I have found that Round2 returns incorrect results if the combination of Number and Decimalplaces becomes large.

For example:

1. Round2(1.23456789, 18) produces the expected result but Round2(1.23456789, 20) gives 0.09223372

2. Round2(123456.123456, 14) produces 92.23372037E3

The bigger the "Number" the smaller the possible "Decimalplaces"

Obviously the internal process of Round2 is producing "out of range numbers" without a trap/limit/flag.

My question is, does anyone know how to determine the limits the Round2 arguments to an acceptable combination range?

Any help much appreciated

Regards Roger