Copy link to clipboard
Copied
Hi,
How do I round this numbers?
10.24 = 10
10.26 = 10.5
10.74 = 10.5
10.76 = 11
in Excel the function is MROUND or CEILING
Simple math: You divide you value by the quantifier, round it and multiply it by the quantifier. In Javascript:
Math.round(value/0.5)*0.5
Mylenium
Copy link to clipboard
Copied
Simple math: You divide you value by the quantifier, round it and multiply it by the quantifier. In Javascript:
Math.round(value/0.5)*0.5
Mylenium
Copy link to clipboard
Copied
check this thread on the "Related conversations", there's a function to round to the nearest quarter, it can be easily edited to round to nearest half