Round Up or Down to nearest 0.5

Hello @stevedawsonuk

Thank you very much for using our plugin. Yes, that’s possible. In this case, you must pass 0.5 as the second parameter of the ROUND operation:

ROUND(3.24, 0.5) returns 3.0
ROUND(3.26, 0.5) returns 3.5
ROUND(3.49, 0.5) returns 3.5
ROUND(3.50, 0.5) returns 3.5
ROUND(3.51, 0.5) returns 3.5

Note that 3.51 is nearest to 3.5 than 4

Best regards.