Explanation

ROUND is used to round a number to a specified number of decimal places.

Syntax

=ROUND(number, num_digits)

Example

=ROUND(125.678,2)

Result: 125.68

Another example:

=ROUND(125.678,0)

Result: 126

Real-World Uses

  • Calculating invoice amounts
  • Financial reports
  • Percentage calculations
  • Average marks
  • Sales reports

Practice

Create a price list with decimal values and round all prices to:

  • 2 decimal places
  • 1 decimal place
  • 0 decimal places
PreviousNext