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:
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: