Rounding function giving different result for similar numbers

Yash1

I am using rounding function to convert 3 decimal places to 2, but the function is giving different results for similar numbers.  

 

	Original Number	Round to 3	Round to 2
P1	31.49496	$31.495	$31.50
P2	35.49528	$35.495	$35.49	This should be 35.50

Formula used for rounding to 3 - Round(n,3)

Formula used for rounding to 2 - Round(n*100)/100

 

 

Yash1

Hi Kavin,

Thanks for the reply.
Round function has been updated with one additional parameter "EXACT" , using this solved my issue.

Cheers,
Yash

kavinkumar

HI @Yash1,

For rounding to 2 digits, can you try this? ROUND(n,2,UP).

Let me know if that works!

Regards,

Kavin.