The ROUND() function takes a number and returns the nearest integer to the argument. Numbers that are exactly half way (ie, end in “.5”) round away from zero.

ROUND(5.4) === ROUND(5.1) === ROUND(4.5) === 5
ROUND(-5.5) === ROUND(-5.9) === ROUND(-6.3) === -6

• CEIL
• FLOOR
• TRUNC
• See all Functions