How to Round Excel?

#Excel Jul 13, 2026

1 / 10

Use `=ROUND(number, num_digits)` to round to a specified number of digits

@HTuse

Use `=ROUNDUP(number, num_digits)` to round up

@HTuse

Use `=ROUNDDOWN(number, num_digits)` to round down

@HTuse

Use `=MROUND(number, multiple)` to round to the nearest multiple

@HTuse

Use `=CEILING(number, significance)` to round up to the nearest specified multiple

@HTuse

Use `=FLOOR(number, significance)` to round down to the nearest specified multiple

@HTuse

Use the Increase Decimal or Decrease Decimal buttons on the Home tab to change displayed decimal places

@HTuse

Use Format Cells to set number formatting and control how values appear

@HTuse

Use `=INT(number)` to round down to the nearest integer

@HTuse

Use `=TRUNC(number, [num_digits])` to remove decimal places without rounding

@HTuse

How To Remove Blank Lines In Excel?