Rounding function giving different result for similar numbers

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

 

 Original NumberRound to 3Round to 2 
P131.49496$31.495$31.50 
P235.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

 

 

Best Answer

  • Yash1
    Answer ✓
    Hi Kavin,

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

    Cheers,
    Yash

Answers