Excel ROUND Function: How to Use It, with Examples
Turkish: YUVARLA

Rounds a number to the number of digits you specify.

ROUND syntax

=ROUND(number, num_digits)

In Turkish Excel: =YUVARLA(sayı; sayı_rakamlar)

ArgumentDescription
numberThe number to round.
num_digitsDigits after the decimal point (negative rounds to the left).

ROUND examples

Sample table:

ABCD
1ProductRegionQuantityPrice
2PenAnkara125
3Notebookİzmir820
4EraserAnkara302
5NotebookAnkara520
6Penİzmir75
=ROUND(D2/3,2)
Result: 1.67

Rounds 5/3 to 2 decimals.

=ROUND(1234.5,-2)
Result: 1200

Rounds to hundreds.

Results were calculated in real Excel.

Tips for ROUND

  • Hiding decimals with cell formatting does not change the value; ROUND does.

Related functions

More formula guides

More tools

About ROUND Function

Rounds a number to the number of digits you specify.

Turkish function names were taken directly from Turkish Excel, and the example results on formula pages were calculated in real Excel. Everything runs in your browser; your data is never uploaded.

How to use ROUND Function

  1. Type the formulaStart typing =ROUND( in a cell; Excel shows the arguments.
  2. Fill in the argumentsSeparate them with commas (semicolons in Turkish Excel).
  3. Press EnterCheck the result; you can also try it in the tester below.

Frequently asked questions

What is ROUND in Turkish Excel?

In Turkish Excel, ROUND is called YUVARLA. Turkish Excel also separates arguments with semicolons (;) instead of commas.

Which Excel versions have ROUND?

ROUND is available in all current Excel versions (2010 and later, Microsoft 365).