Most of us are taught that for digits below 5, round down, for 5 and greater round up.

IE 4.725 to 2 decimal places gives 4.73. This is the result given by Round2.

Numberformat2 gives the result 4.72 after a bit of research I found that this is correct. Always rounding up 5 is simplistic and produces errors.

The more accurate method [simplistically put] is if the digit preceding the 5 is even, round down, if it is odd, round up.

IE 4.725 to 2 decimal places is 4.72. 4.735 to 2 decimal places is 4.74.

Numberformat2 gives these results.

This link gives a much better/precise explanation:

__http://www.chemteam.info/SigFigs/Rounding.html__

Thanks to Erel for helping correct a misconception I have carried for most of my life.

Regards Roger