Round (Rounds a number to a specified number of digits)

What Does It Do?

This function rounds a number to a specified amount od decimal places.

If 0 is used the number is rounded to the nearest whole number.

If a negative amount of rounding is used the figures to the left of the decimal point are rounded.

Syntax

=ROUND(NumberToRound,DecimalPlacesToUse)

Formatting

No special formatting is needed.