Math & Trig

CEILING Function in Excel

Rounds a number up to the nearest multiple of significance.

Syntax

  • =CEILING(number, significance)

Arguments

  • number (required): The value to round up
  • significance (required): The multiple to round up to

Examples

  • =CEILING(2.5, 1) - Round up to nearest integer - Result: 3
  • =CEILING(4.42, 0.05) - Round up to nearest 0.05 - Result: 4.45

Excel CEILING function overview

  • CEILING rounds a number up to the nearest multiple of significance — always toward +∞ for positive numbers in classic CEILING.
  • Syntax: =CEILING(number, significance). Both arguments must be numeric; significance cannot be zero.
  • Category: Math & Trig. Common in pricing (nickels, quarters), packaging (case packs), and time rounding (15-minute blocks).
  • Modern alternative: [CEILING.MATH](/functions/ceiling-math/) handles negative numbers more predictably than legacy CEILING.

CEILING arguments: number and significance

  • number (required): the value to round up — price, quantity, hours, or formula result.
  • significance (required): the multiple to round up to — 1 for integers, 0.05 for nickels, 5 for packs of five, TIME(0,15,0) for quarter hours.
  • Classic CEILING requires number and significance to have the same sign; mixed signs return #NUM! in older behavior.
  • Example: =CEILING(4.42, 0.05) returns 4.45 (next nickel up). =CEILING(47, 10) returns 50 (next ten).

CEILING vs CEILING.MATH vs ROUNDUP

  • CEILING — round up to a multiple; legacy sign rules; use when matching older workbook behavior.
  • CEILING.MATH — round up with optional mode for negatives; preferred for new models in M365.
  • ROUNDUP — round up to decimal places (digits), not arbitrary multiples — =ROUNDUP(4.42, 1) → 4.5.
  • MROUND — nearest multiple (up or down) — use when you need closest pack size, not always up.

Pricing, inventory, and time examples

  • Retail price to $0.99 ending: =CEILING(cost*1.35, 1)-0.01 after margin calc (adjust rule for your policy).
  • Order in full cartons of 6: =CEILING(units_needed, 6) to round ordered quantity up to whole cases.
  • Billable time to 15 minutes: =CEILING(duration, TIME(0,15,0)) when duration is an Excel time value.
  • SaaS seat tiers: =CEILING(active_users, 10)*price_per_10 when billing blocks of ten seats.

People also ask

  • What is CEILING in Excel? — A function that rounds a number up to the nearest specified multiple.
  • CEILING vs ROUNDUP? — CEILING uses a significance multiple; ROUNDUP uses decimal-place precision.
  • Why #NUM! on CEILING? — Sign mismatch between number and significance in classic CEILING, or significance is 0.
  • How to round up to nearest 5? — =CEILING(A1, 5) rounds up to the next multiple of five.

Common errors

  • #VALUE! if arguments are non-numeric
  • Signs must match

Use cases

  • Pricing calculations
  • Time rounding
  • Inventory quantities

Frequently asked questions

  • What's the difference between CEILING and ROUNDUP? CEILING rounds to a multiple (like 0.05 or 5), while ROUNDUP rounds to decimal places. CEILING(4.42, 0.05)=4.45 rounds to nearest nickel. ROUNDUP(4.42, 1)=4.5 rounds to 1 decimal place. Use CEILING for pricing, ROUNDUP for precision.
  • How do I round time up to the nearest 15 minutes? Convert time to decimal hours, use CEILING, convert back: =CEILING(A1*24*4, 1)/(24*4) rounds to nearest 15 min. Or =CEILING(A1, TIME(0,15,0)) works directly with time values.
  • Why does CEILING give an error with negative numbers? In older Excel, CEILING requires both arguments to have the same sign. Use CEILING.MATH instead: =CEILING.MATH(-4.2, 2) works correctly. CEILING.MATH is the modern, more flexible version.

Editorial review

  • Reviewed by Excel.Directory Editorial Team. Updated May 2026.

When to use CEILING

  • Pricing calculations — common Math & Trig scenario for CEILING.
  • Time rounding — common Math & Trig scenario for CEILING.
  • Inventory quantities — common Math & Trig scenario for CEILING.

CEILING in the Math & Trig category

  • Browse all Math & Trig functions at /categories/math-trig/ for related formulas.
  • CEILING syntax: =CEILING(number, significance)
  • number (required): The value to round up
  • significance (required): The multiple to round up to
  • Confirm CEILING arguments match the syntax shown above before filling down.
  • Lock table and range references with $ when copying formulas across rows or sheets.

Formula checklist before you copy down

  • Confirm CEILING arguments match the syntax shown above before filling down.
  • Lock table and range references with $ when copying formulas across rows or sheets.
  • If results look wrong, check for text stored as numbers and invisible spaces with TRIM.
  • Spot-check three known input rows manually against expected output.

Related Excel functions

  • FLOOR (/functions/floor/): Rounds a number down to the nearest multiple of significance.
  • ROUND (/functions/round/): Rounds a number to a specified number of digits.
  • ROUNDUP (/functions/roundup/): Rounds a number up, away from zero.
  • MROUND (/functions/mround/): Rounds a number to the nearest specified multiple.

Errors to watch for

  • #VALUE! if arguments are non-numeric — review causes on linked error pages in the directory.
  • Signs must match — review causes on linked error pages in the directory.

Copy-paste audit workflow

  • Enter CEILING on three test rows with known expected output documented on a QA tab.
  • Fill down only after absolute references are locked on lookup tables and rate tables.
  • Compare against manual calculation or a calculator for financial and statistical functions.
  • Search this directory for comparison guides when choosing between similar functions in the same category.

CEILING worked examples to copy

  • =CEILING(2.5, 1) — Round up to nearest integer. Expected result: 3.
  • =CEILING(4.42, 0.05) — Round up to nearest 0.05. Expected result: 4.45.

CEILING reference summary for crawlers and offline review

  • CEILING belongs to the Math & Trig category in Excel. Rounds a number up to the nearest multiple of significance.
  • Full syntax: =CEILING(number, significance). Open /functions/ceiling/ for parameters, FAQs, and related pages.
  • Common mistakes: #VALUE! if arguments are non-numeric; Signs must match
  • Pair this function with comparison guides when another Excel formula might fit the same task better.
  • Review fix-excel-formula-errors when unexpected errors appear after upgrading Excel or sharing across locales.