| Türk | İngilizce |
|---|---|
| TAVANAYUVARLA.MATEMATİK | CEILING.MATH |
Definition and Usage of the CEILING.MATH / TAVANAYUVARLA.MATEMATİK Function
The CEILING.MATH function, known in Turkish as TAVANAYUVARLA.MATEMATİK, rounds a specified number up to the nearest integer or specified multiple, if provided. This function is highly useful in various areas such as financial calculations and inventory management.
Syntax and Parameters
=CEILING.MATH(number, [factor], [mode])- number: The real number to be rounded.
- factor (optional): The multiple to which the rounding should adhere. If omitted, the default is 1.
- mode (optional): Determines the direction of rounding. If 0 or not specified, rounding is away from zero. If -1, rounding is towards zero.
Example Uses
Below are several examples of using the CEILING.MATH function in Excel and Google Sheets:
| Formula | Result | Description |
|---|---|---|
|
3 | 2.5 is rounded up to the nearest larger whole number, which is 3. |
|
4 | 2.5 is rounded to the nearest multiple of 2, resulting in 4. |
|
-3 | -3.1 is rounded towards zero to -3. |
Practical Application Scenarios
1. Usage in Pricing Strategies
When setting the price of a product, you might need to round up to a certain multiple for standardization purposes. For example, you may prefer setting a price of 20 TL rather than 19.99 TL. The formula useful in this scenario would be:
=CEILING.MATH(19.99, 1)This formula rounds 19.99 up to the next multiple of 1, resulting in a price of 20 TL.
2. Rounding Inventory Quantities
When rounding the quantity of products in a warehouse to full box quantities, consider a scenario where each box holds 12 items and you have an order for 25 items:
=CEILING.MATH(25, 12)This formula rounds 25 to the nearest multiple of 12 (which is 36), resulting in the need for 3 boxes.
This HTML formatted article provides a detailed guide on using the CEILING.MATH function (in Turkish, TAVANAYUVARLA.MATEMATİK) in Excel and Google Sheets. It includes syntax descriptions, practical examples, and uses in specific scenarios such as pricing strategies and inventory management.
Daha fazla bilgi: https://support.microsoft.com/tr-tr/office/tavanayuvarla-matematİk-işlevi-80f95d2f-b499-4eee-9f16-f795a8e306c8