Subject Re: Rounding puzzle
From Akshat Kapoor <akshat.kapoor@kapoorsons.in>
Date Mon, 9 Dec 2019 19:48:07 +0530
Newsgroups dbase.getting-started
Attachment(s) high precision.png

On 09-12-2019 19:31, Robbie Nott wrote:
> Converting inches to mm
 >
> Set decimals to 4
 >
> ? 3/8                 = 0.3750
 > ? 25.4 * 0.3750            = 9.5250
 > ? Round(25.4 * 0.3750, 2)    = 9.5200
 > ? Round(9.5250, 2)        = 9.5300
 >
> These last 2 Round() statements should be identical ?
 >
> Please assist with this head scratcher
 > Many thanks
 >

Try using
set highprecision on

Some results are attached.

Regards
Akshat