| Türk | İngilizce |
|---|---|
| YUVARLA | ROUND |
The ROUND function, known as YUVARLA in Turkish, is used to round a specified number to a desired number of decimal places. It operates in a very similar manner in both Excel and Google Sheets. This function is commonly used in financial calculations, accounting, or whenever you need to display numerical data at a certain level of precision.
Rounding Sales Data
A business wants to calculate the total sales amount using the unit price of its products and the quantity sold. However, this calculation can often result in lengthy decimal numbers, and the business may want to round these numbers to two decimal places.
Example: If the unit price of a product is 17.567 TL and the quantity sold is 150 units:
=B17*J17
We use this formula to calculate the total revenue. Suppose the result is 2635.05, although the actual calculation might include more decimal places. In this case, we can use the ROUND function to round the number:
=ROUND(B17*J17, 2)
This formula would round a value like 2635.055 to 2635.06.
Handling Fractions in Financial Statements
In a financial statement, calculating various financial indicators often requires high precision. However, when presenting results, rounding to a specific number of decimal places may be necessary.
Example: When calculating the annual revenue of a company that ends in various fractional numbers, to round off the revenue:
=ROUND(H25, 0)
This formula rounds the value stored in cell H25 to the nearest whole number. For instance, 48759.5 would be rounded to 48760.
| Function | Description |
|---|---|
| Number | The number to be rounded. |
| Digit | The number of decimal places to round the number. Positive values affect the decimal part, negative values affect the integer part. |
The function operates based on the specified “digits”, rounding numbers mathematically. Values of 0.5 and above are always rounded up, while values below 0.5 are rounded down.
The ROUND function has a wide range of applications; it is utilized in cost calculations, statistical reporting, and scientific data processing, among other areas. It helps to reduce user errors and makes data more readable.
Daha fazla bilgi: https://support.microsoft.com/tr-tr/office/yuvarla-işlevi-c018c5d8-40fb-4053-90b1-b3e7f61a213c