Google Sheets-funktion

CEILING

Rounds a number up to the nearest integer or to the nearest multiple of significance.

Skapa en formel med AI Samma funktion i Excel

Den här funktionen fungerar likadant i Google Kalkylark som i Excel — samma syntax och argument.

Syntax

CEILING(number, significance)

The CEILING function rounds a given number away from zero to the nearest multiple of the specified significance. It is commonly used for pricing or inventory calculations where values must be rounded up to a specific unit.

Argument

numberobligatorisktThe value you want to round.
significanceobligatorisktThe multiple to which you want to round.

Exempel

=CEILING(2.5, 1)

Resultat: 3

Rounds 2.5 up to the nearest multiple of 1.

=CEILING(10, 3)

Resultat: 12

Rounds 10 up to the nearest multiple of 3, which is 12.

Vanliga frågor

What happens if the number is already a multiple of significance?

The function returns the number unchanged.

Does CEILING work with negative numbers?

Yes, but it rounds away from zero, meaning it becomes more negative.

Relaterade funktioner

FLOOR ROUNDUP ROUND