What is the round function in excel used for?

Answer 1

ROUND is a function that returns a number rounded to a specified number of digits.

Syntax: =ROUND( number, digits )

number is the number to round

digits is the number of digits to round the number to

EXAMPLES:

=ROUND(1/3,2) will return 0.33

=ROUND(1/6,2) will return 0.17

Answer 2

The ROUND function returns a number rounded to a specified number of digits.

Syntax: ROUND(number,digits)

number = number to round.

digits = number of digits to round the number to.

Answer 3

The ROUND function has just two arguments, which are the value to round and the amount of decimal places to round it to.

=ROUND( 7.391, 1 )

The result of the above would be 7.4 as it rounds the value to one decimal place.

Answer 4

A round function can round a number up or down to show with a set amount of decimal places. The ROUND function rounds to the nearest value. The ROUNDUP function always rounds a number up and the ROUNDDOWN function always rounds down. They all take the same arguments, which are the value you want to round and the amount of decimal places to display. For example:

=ROUND(6.7541,2) will round 6.7541 to 2 decimal places and display 6.75 as the result.