Round to the nearest 0.5
Posted: Thu Feb 06, 2020 2:12 pm
Hi guys, I need some help to round some values in a report following some rules.
Example:
From 7.1 till 7.4 it should be rounded to 7.5
From 7.6 till 7.9 it should be rounded to 8.0
I know that the Round function follows the international math rounding rules. Is there a way to do this ?
I appreciate any ideas or help with this question.
Example:
From 7.1 till 7.4 it should be rounded to 7.5
From 7.6 till 7.9 it should be rounded to 8.0
I know that the Round function follows the international math rounding rules. Is there a way to do this ?
I appreciate any ideas or help with this question.