Use of the ROUND function in Excel

Causes Excel to display the desired number of decimal places, but remember the hidden digits thereafter.

Has no mathematical consequence for values in cells where a formula refers back to the rounded cell.

Is recommended when working with financial values as rounding to $2$ will correctly display dollars and cents.

Causes Excel to display the desired number of decimal places, and forget digits thereafter.