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