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
Check out the ROUNDDOWN function.
Found the answer using the Floor formula
Thanks again Paul!
Happy to help. 👍️