What does the ROUND function do and how does it differ from ROUNDDOWN?

Question

Microsoft Excel — Medium

What does the ROUND function do and how does it differ from ROUNDDOWN?

Accepted Answer

The ROUND function applies standard rounding rules, whereas ROUNDDOWN always rounds toward zero. This distinction is crucial. ROUND rounds up if the digit is 5 or greater, but ROUNDDOWN does not.