Rounding to nearest 0.5
Kate Kelley
✭✭✭✭
Is there a way to have a column round down to the nearest 0.5 increments? Never up though.
If 1.7, would round down to 1.5
If 2.3, would round down to 2.0
Best Answer
-
Check out the ROUNDDOWN function.
Answers
-
Found the answer using the Floor formula
-
Check out the ROUNDDOWN function.
-
Thanks again Paul!
-
Happy to help. 👍️