The ROUND() function acts to round values up and down. This means that the round function can evaluate the nearest "whole" place value effectively approximating a value.

• The syntax for the function is ROUND(number,)

The round function requires two arguments. The first is the value of the data that is to be rounded, the second is the number of decimal placed the data is to be rounded to.

For example: ROUND(4.52, 1) = 4.5 The number 4.52 rounded down to one decimal place becomes 4.5 as the nearest whole tenth is five.

[Compare to roundup and rounddown functions]

• Click on the cell where you want the result to appear.
• Type " =ROUND( ".
• Enter the data value.
• Type a comma "," and enter the number of decimal places the data is to be rounded to.
• Type " ) " then press the "Enter" key

• Click on the cell where you want the result to appear.
• Type " =ROUND( ".
• Enter the coordinate of the data cell.
• Type a comma "," and enter the number of decimal places the data is to be rounded to.
• Type " ) " then press the "Enter" key

Note: The Ripple effect and auto update.

• Click on the cell where you want the result to appear.
• Type " =ROUND( ".
• Enter the coordinate of the data cell.
• Type a comma "," and enter the number of decimal places the data is to be rounded to.
• Type " ) " then press the "Enter" key
• Drag the fill handle to fill the column.

Note: The intelligent autofill.