Excel FunctionsLesson 105Free preview

ROUND

This lesson is part of Excel · All levels

Summary

ROUND is an Excel numerical function that rounds a number to a certain decimal number. The syntax is ROUND(number, num_digits), where num_digits are positive for decimal and negative for pre-comma. The ROUNDUP and ROUNDDOWN variants rotate in a certain direction.

Key points

Syntax: ROUND(bilangan, jumlah_desimal)
Positive num_digits = decimal, negative = position before the comma
Roundup is always up, rounddown is always down
Rotate 0.5 on a round always away from zero

Full lesson

Code examples and quizzes

Full lessons, code examples, and quizzes are available to subscribers. 5 questions.