Home › Functions › Math & Trig › CEILING.PRECISE
fx
CEILING.PRECISE
Math & Trig  ·  Since: Excel 2003  ·  9 languages

Returns a number that is rounded up to the nearest integer or to the nearest multiple of significance. Regardless of the sign of the number, the number is rounded up. However, if the number or the significance is zero, zero is returned.

🌐 Translations

English CEILING.PRECISE
Deutsch OBERGRENZE.GENAU
Français PLAFOND.PRECIS
Español MULTIPLO.SUPERIOR.EXACTO
Italiano ARROTONDA.ECCESSO.PRECISA
Português TETO.PRECISO
Nederlands AFRONDEN.BOVEN.NAUWKEURIG
Polski ZAOKR.W.GÓRĘ.DOKŁ
Русский ОКРВВЕРХ.ТОЧН

📦 Availability

Excel versionAvailable
Excel 2007 ✓
Excel 2013 ✓
Excel 2019 ✓
Excel 2021 ✓
Microsoft 365 ✓
Translate a formula with this function
fx EN
fx DE

⌨ Syntax

CEILING.PRECISE(number,[significance])

Arguments

number (required) — The value to be rounded.
significance (optional) — The multiple to which number is to be rounded. If significance is omitted, its default value is 1.

▶ Examples

=CEILING.PRECISE(4.3)
=CEILING.PRECISE(-4.3)
=CEILING.PRECISE(4.3,2)

Related functions

Copied to clipboard