ROUND number on 0.5

Question
1

Hi Do you know if its possible to round numbers like shown bellow with a formula?
Examples:
0.3 => 0.5
0.5 => 0.5
0.6 => 0.5
0.8 => 1
1.2 => 1
1.3 => 1.5
1.5 => 1.5
…

I know that thats not “rounding” but thats what im trying to do
Thank you in advance

1 Like
2

I’ll tag here to follow because I’m also interested.

1 Like
3

@Dimos_Vamvourellis
ROUND(var*2,0)/2 should do it.

4 Likes
4

Well done @Phil_Evans !! really impressed, it works as explained.