Microsoft Support
support.microsoft.com › en-us › office › ceiling-function-0a5cd7c8-0720-4f0a-bd2c-c943e510899f
CEILING function - Microsoft Support
If number is negative, and significance is negative, the value is rounded down, away from zero. If number is negative, and significance is positive, the value is rounded up towards zero. Copy the example data in the following table, and paste it in cell A1 of a new Excel worksheet.
Ablebits
ablebits.com › ablebits blog › excel › excel formulas › rounding in excel: round, roundup, rounddown, floor, ceiling functions
Rounding in Excel: ROUND, ROUNDUP, ROUNDDOWN, FLOOR, CEILING functions
May 3, 2023 - If number is positive and significance ... the value is rounded up, towards zero, as in row 6. If number and significance are negative, the value is rounded down, as in row 8. The INT function rounds a number down to the nearest ...
Videos
Microsoft Excel - Using the CEILING and FLOOR functions
03:35
CEILING, FLOOR, ROUND Functions in Microsoft Excel - YouTube
02:47
CEILING Function for Rounding Numbers in Excel - YouTube
04:16
How to use MROUND, FLOOR and CEILING functions in Excel - Office ...
01:46
How to Round amounts to the nearest Penny in Excel - Office 365 ...
02:04
CEILING and FLOOR Excel Functions (with examples) - YouTube
ExcelFind
excelfind.com › excel-functions › excel-ceiling-function
How to use the Excel CEILING function - ExcelFind.com
February 12, 2024 - The Excel ROUNDDOWN function rounds a number down, away from zero, to a specified number of digits, useful for conservative estimations.
Exceljet
exceljet.net › ceiling function
Excel CEILING function | Exceljet
September 11, 2021 - If number and significance are both negative, CEILING rounds down, away from zero. If number is negative, and significance is positive, CEILING rounds up, towards zero. For more control over how CEILING rounds negative numbers, see the CEILING.MATH ...
Corporate Finance Institute
corporatefinanceinstitute.com › home › resources › ceiling function
CEILING Function - Formula, Calculate, Example, Sample
June 19, 2025 - Here 3 is n (the number of rows to group) and 4 is an offset to normalize the first row to 1 as the first row of data is in row 6. The CEILING function rounds incoming values up to a given multiple of n. Essentially, the CEILING function counts ...
Microsoft Support
support.microsoft.com › en-us › office › ceiling-math-function-80f95d2f-b499-4eee-9f16-f795a8e306c8
CEILING.MATH function - Microsoft Support
Here is the formula syntax and use of the CEILING.MATH function in Microsoft Excel. The CEILING.MATH function rounds a number up to the nearest integer or, optionally, to the nearest multiple of significance.
ExcelFind
excelfind.com › excel-functions › excel-ceiling-math-function
How to use the Excel CEILING.MATH function - ExcelFind.com
February 12, 2024 - The Excel ROUNDDOWN function rounds a number down, away from zero, to a specified number of digits, useful for conservative estimations. The Excel ROUND function rounds a number to a specified number of digits, crucial for accurate financial ...
My Online Training Hub
myonlinetraininghub.com › home › blog › excel ceiling and floor functions
Excel CEILING and FLOOR Functions • My Online Training Hub
April 19, 2020 - Excel CEILING and FLOOR Functions allow you to round values up or down to the nearest value divisible by a specified number. e.g ending in 95 cents.
Spreadsheeto
spreadsheeto.com › home › blog › how to use the ceiling function in excel – and why!
How to Use the CEILING Function in Excel - and Why!
January 10, 2026 - However, the CEILING function only rounds up the numbers based on the significance argument. Whereas, the MROUND function can round up or round down the number. This depends upon the remainder resulting from the division of the number argument ...
Futurevisioncomputers
futurevisioncomputers.com › home › advance excel
ROUNDUP CEILING and FLOOR Functions in Excel
January 17, 2026 - The CEILING function rounds up to the nearest multiple of a number you define—called the significance. ... The FLOOR function is the opposite of CEILING—it rounds down to the nearest multiple of significance.
eFinancialModels
efinancialmodels.com › home › excel, google sheets, & co. › excel functions and formulas › another way to round up numbers with excel’s ceiling function
How to Use Ceiling Function in Excel | eFinancialModels
October 22, 2023 - Rounding does not happen in Excel’s CEILING function if the number is an exact multiple of significance. For example, rounding the number 5 to the nearest multiple of 5. CEILING formula in Excel =CEILING(5,5) will return the number 5. If you want to round numbers down with multiples, use ...
MyExcelOnline
myexcelonline.com › home › the ultimate guide to ceiling function in excel
The Ultimate Guide to Ceiling Function in Excel | MyExcelOnline
January 26, 2025 - The MROUND function rounds to the nearest specified multiple, which can go up or down. The FLOOR function is effectively the opposite of CEILING, always rounding down to the specified multiple.
Exceljet
exceljet.net › ceiling.math function
Excel CEILING.MATH function | Exceljet
September 11, 2021 - To round to the nearest multiple (up or down) see the MROUND function. CEILING.MATH works like CEILING, but provides control for rounding negative values. The mode argument has no effect on positive numbers.
ExtendOffice
extendoffice.com › excel tips › excel functions › excel ceiling function
Excel CEILING function
5. The number is positive, but the significance is negative, the result returns #NUM! value. ... Excel CEILING.MATH The CEILING.MATHfunction rounds number up to nearest multiple or the nearest integer, and the Mode argument decide to round negative toward or far away from zero.
CodeLucky
codelucky.com › home › excel ceiling function: complete guide to rounding up numbers
Excel CEILING Function: Complete Guide to Rounding Up Numbers - CodeLucky
August 27, 2025 - Unlike standard rounding functions that round to the nearest integer, CEILING always rounds away from zero to the next highest multiple of your chosen significance value. This function is particularly useful when you need to ensure values meet ...
Office Watch
office-watch.com › home › all about ceiling() and floor() excel rounding options
All about Ceiling() and Floor() Excel rounding options - Office Watch
April 10, 2023 - 0 Zero – is the default, rounding TO zero (a higher number),. -1 (or any negative number) – rounds AWAY from zero (a lower number). Excel’s Floor() function rounds a number DOWN to the nearest specified multiple.
Ajelix
ajelix.com › home › resources › formulas and functions › ceiling function ms excel
How To Use CEILING Function in Excel Guide With Examples - Ajelix
March 14, 2024 - What is the difference between FLOOR and CEILING functions in Excel? FLOOR is a function that rounds a number down to the nearest integer, while CEILING rounds a number up to the nearest integer.
Top answer 1 of 2
3
There is an alternative to CEILING using a little math and ROUNDUP.
=ROUNDUP(A1/2, 0)*2
It may be important to note how CEILING works with negative numbers. CEILING always rounds to the numerically larger number.
For the following examples, assume 3 in A1 and -3 in A2.
=CEILING(A1, 2) 'rounds up to +4
=CEILING(A2, 2) 'rounds up to -2
On the other hand, ROUNDUP always rounds away from zero.
=ROUNDUP(A1/2, 0)*2 'rounds up to +4
=ROUNDUP(A2/2, 0)*2 'rounds away from zero to -4
Conversely, ROUNDDOWN and FLOOR (the inverse of ROUNDUP and CEILING) operate in the same manner by in the opposite 'direction'.
2 of 2
0
Use CEILING(A1, 2). CEILING rounds the first parameter up to the nearest multiple of the second parameter.
Microsoft Support
support.microsoft.com › en-us › office › iso-ceiling-function-e587bb73-6cc2-4113-b664-ff5b09859a83
ISO.CEILING function - Microsoft Support
The optional multiple to which number is to be rounded. If significance is omitted, its default value is 1. Note: The absolute value of the multiple is used, so that the ISO.CEILING function returns the mathematical ceiling irrespective of the signs of number and significance. Copy the example data in the following table, and paste it in cell A1 of a new Excel ...
Excel Forum
excelforum.com › excel-formulas-and-functions › 1058272-round-ceiling.html
Round.ceiling [SOLVED]
For example, if the most precise you need to be is 1 minute (anything that computes less 1 hour and <60 seconds will be rounded down to 1 hour, anything that computes 1 and >60 seconds will be rounded up) will subtract something less than one minute (maybe 20 or 40 seconds) from the difference. So, your main function becomes =b1-a1-"30 seconds" (I'm not very proficient with Excel's time values, so I'm not exactly sure how to put that into your formula), then use the Ceiling function like you currently use it.