Truncate to 2 decimal is not working perfectly

Hi Experts,
I am using the “round” function to truncate to 2 decimal numbers from “.”
Now when I want to enter 8.86 and 8.87, the rounded value will be 8.87. But the average shows: 8.86.
Please see the screenshot:

I want the average value will be 8.87.
Many thanks.

Welcome back to the community, @tanzilhuda! It seems like you will need to keep a condition where if the third place value is greater than 5, add 0.01 to the result. Maybe you could do this with an if-statement.

Maybe you could also give it a try by following this post discussed previously:

In addition, you could also refer to these posts discussed previously:

This one too …