ROUND rounds a number to the number of decimal places you name.
Syntax
ROUND(number, num_digits)
When to use it
Money, above all. Two decimal places keeps totals honest and stops a column of prices adding up to something a penny out.
What trips people up
Formatting a cell to two decimal places only changes how it looks; the hidden digits are still there and still counted in totals. ROUND changes the value itself, which is the difference that matters when the figures have to add up.
Set by your computer's language, not by the file. A frequent cause of a correct-looking formula being rejected.
Excel version
XLOOKUP, IFS, TEXTBEFORE and TEXTJOIN need Microsoft 365 or 2021; older versions return #NAME? instead. Choosing the older one switches every walkthrough to a formula that works there.
