Kako koristiti funkciju ISO.CEILING u Excelu

Description of the Function

The ISO.CEILING function is a financial tool utilized in both Microsoft Excel and Google Sheets. It serves to round a number up to the nearest whole number or to the nearest multiple of a specified value. This function is particularly useful in accounting and financial applications where a standardized method for rounding numbers according to international standards is required.

Syntax and Parameters

The syntax for the ISO.CEILING function is as follows:

ISO.CEILING(number, [factor])
  • number – The value that is to be rounded up.
  • factor – An optional parameter, specifying the multiple to which the number should be rounded. The default value is 1.

Usage Examples

Here is a basic example of the ISO.CEILING function:

=ISO.CEILING(4.3)

This example rounds the number 4.3 up to the nearest whole number, resulting in 5.

An example of rounding to multiples other than 1:

=ISO.CEILING(4.3, 0.5)

In this case, 4.3 is rounded up to the nearest multiple of 0.5, which is 4.5.

Practical Examples

Case 1: Financial Planning

Calculate the monthly payments of a loan amounting to 23,347 CZK, considering that all payments must be rounded up to the nearest hundred.

=ISO.CEILING(23347 / 12, 100)

Here we divide the total amount of 23,347 CZK by twelve and then use the ISO.CEILING function to round up to the nearest hundred. The result will be 1,950 CZK.

Case 2: Inventory Management

Imagine you need to order packages of components that are sold in groups of 25 units. If you require 307 units, how many packages should you order?

=ISO.CEILING(307 / 25)

Here we divide the required number of units, 307, by twenty-five. Using the ISO.CEILING function, we round the result up to determine the necessary number of packages to order. The result is 13 packages.

This revised content provides a clear, professional guide on the use of the ISO.CEILING function in MS Excel and Google Sheets, explaining its syntax, parameters, and practical applications in various scenarios.

Více informací: https://support.microsoft.com/cs-cz/office/iso-ceiling-funkce-e587bb73-6cc2-4113-b664-ff5b09859a83

Další funkce
Vrátí arkustangens čísla
Zaokrouhlí číslo na nejbližší celé číslo nebo na nejbližší násobek zadané hodnoty Číslo bude zaokrouhleno nahoru bez ohledu na jeho znaménko
Přiřadí názvy výsledkům výpočtu a umožní tak ukládání mezilehlých výpočtů, hodnot nebo definování názvů ve vzorci
Vrátí nejmenší společný násobek
Vrátí přirozený logaritmus čísla
Vrátí dekadický logaritmus čísla
Vrátí logaritmus čísla při zadaném základu