I am using rounding function to convert 3 decimal places to 2, but the function is giving different results for similar numbers.
Formula used for rounding to 3 - Round(n,3)
Formula used for rounding to 2 - Round(n*100)/100
Go to Solution.
View solution in original post
For rounding to 2 digits, can you try this? ROUND(n,2,UP).
Let me know if that works!