As in =CEILING.MATH(Q7*130%,0.5)? EDIT: Use MROUND() instead of CEILING.MATH() if you don't always want to round up. Answer from Anonymous1378 on reddit.com
Microsoft Support
support.microsoft.com › en-us › office › ceiling-function-0a5cd7c8-0720-4f0a-bd2c-c943e510899f
CEILING function - Microsoft Support
Returns number rounded up, away from zero, to the nearest multiple of significance. For example, if you want to avoid using pennies in your prices and your product is priced at $4.42, use the formula =CEILING(4.42,0.05) to round prices up to the nearest nickel.
Wall Street Mojo
wallstreetmojo.com › home › all blogs › excel resources › excel ceiling function
How to use the CEILING Function in Excel? (with Examples)
December 20, 2024 - The Excel CEILING function is very similar to the floor function in Excel. Still, the result is just the opposite of the floor function. The floor function gives us the result of the less significance and CEILING formula provides us with the ...
How to use ceiling function in the same cell where a multiplication formula occurs
u/Nitropanel - Your post was submitted successfully. Once your problem is solved, reply to the answer(s) saying Solution Verified to close the thread. Follow the submission rules -- particularly 1 and 2. To fix the body, click edit. To fix your title, delete and re-post. Include your Excel version and all other relevant information Failing to follow these steps may result in your post being removed without warning. I am a bot, and this action was performed automatically. Please contact the moderators of this subreddit if you have any questions or concerns. More on reddit.com
5
1
January 3, 2024excel - CEILING Function - Round to next even number - Stack Overflow
How do I make the CEILING function work to automatically assume a cell value is to the nearest even number? Examples: If I have a value of 4.25, how do I get it to automatically round to 6? If I... More on stackoverflow.com
Alternative to FLOOR and CEILING functions
Hi! I'm looking for an alternative for the FLOOR and CEILING functions that I use in Excel. For context, I purchase paper, and buy it in skids and fill the remaining balance in smaller packages. In Excel, I use a formula that references a lookup table to tell me how many sheets of paper come ... More on community.smartsheet.com
windows phone 7 - Excel: Alternative to CEILING for rounding to nearest value - Stack Overflow
Normally I ask about work stuff so here's something different. To approach my new year's resolution in the nerdiest way possible, I'm creating a gym program in an excel file. I'll be doing ramped s... More on stackoverflow.com
Videos
03:35
CEILING, FLOOR, ROUND Functions in Microsoft Excel - YouTube
01:24
How to use FLOOR and CEILING Function of Excel | Excel Amazing ...
Microsoft Excel - Using the CEILING and FLOOR functions
02:04
CEILING and FLOOR Excel Functions (with examples) - YouTube
02:47
CEILING Function for Rounding Numbers in Excel - YouTube
01:28
How to use the CEILING.MATH() and FLOOR.MATH() function in Excel: ...
Keynote Support
keynotesupport.com › excel-functions › how-to-use-ceiling-function-excel.shtml
How to Use the CEILING function of Excel - Keynote Support
This tutorial explains how to use the CEILING function and provides examples. The CEILING function works opposite of the FLOOR function, and is similar to the MROUND function, which rounds up or down to the nearest multiple.
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.
LibreOffice
help.libreoffice.org › latest › en-US › text › scalc › 01 › func_ceiling.html
Ceiling functions
The function returns an error if the number and significance values have opposite signs. If the spreadsheet is exported to Microsoft Excel, the CEILING function is exported as the equivalent CEILING.MATH function that has existed since Excel 2013.
Reddit
reddit.com › r/excel › how to use ceiling function in the same cell where a multiplication formula occurs
r/excel on Reddit: How to use ceiling function in the same cell where a multiplication formula occurs
January 3, 2024 -
Hello, in cell R7 I have this formula =Q7*30%+Q7 which gives the answer as a decimal. I want to round the answer to the nearest 0.5. For example the cell is currently giving me 14.76 but I want it to display 15. I know how to achieve this by creating another column with the ceiling function but I want to know if it's possible to use the same R7 cell to run a multiplication which is =Q7*30%+Q7 and then round that number up in the same cell. How can I achieve this?
Top answer 1 of 5
1
u/Nitropanel - Your post was submitted successfully. Once your problem is solved, reply to the answer(s) saying Solution Verified to close the thread. Follow the submission rules -- particularly 1 and 2. To fix the body, click edit. To fix your title, delete and re-post. Include your Excel version and all other relevant information Failing to follow these steps may result in your post being removed without warning. I am a bot, and this action was performed automatically. Please contact the moderators of this subreddit if you have any questions or concerns.
2 of 5
1
As in =CEILING.MATH(Q7*130%,0.5)? EDIT: Use MROUND() instead of CEILING.MATH() if you don't always want to round up.
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.
Corporate Finance Institute
corporatefinanceinstitute.com › home › resources › ceiling function
CEILING Function - Formula, Calculate, Example, Sample
June 19, 2025 - The Excel CEILING function[1] is categorized under Math and Trigonometry functions. The function will return a number that is rounded up to a supplied number that is away from zero to the nearest multiple of a given number. MS Excel 2016 handles both positive and negative arguments. The function is very useful in financial analysis as it helps in setting the price after currency conversion, discounts, etc.
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 - I get $3.97 for row 25 so I think ... I may change your formula to remove ‘CEILING’ part. See below, =FLOOR(D25,1)+IF((D25-FLOOR(D25,1))<0.5, 0.47, 0.97)....
Exceljet
exceljet.net › ceiling function
Excel CEILING function | Exceljet
September 11, 2021 - The core of this formula is the COUNTA function, configured with an expanding range like this: COUNTA($B$5:B5) As the formula is copied down the column, the range starting with B5 expands to include each new row, and COUNTA returns a running count of all non-blank entries in the range. The result... The Excel CEILING function rounds a number up to a given multiple.
YouTube
youtube.com › watch
CEILING and FLOOR Excel Functions (with examples) - YouTube
CEILING and FLOOR allow you to round up or down to a multiple which can be the nearest whole number or decimal (compared to the nearest number of decimal pla...
Published October 21, 2011
LiveFlow
liveflow.com › product-guides › ceiling-math-function-in-excel-explained
CEILING.MATH Function in Excel: Explained
It is an updated version of the CEILING function, introduced in Excel 2013. Here's how the CEILING.MATH function works: ... If the "Number" is positive and the "Significance" is positive, CEILING.MATH rounds up the number to the nearest multiple of the significance. If the "Number" is negative and the "Significance" is positive, CEILING.MATH rounds up the absolute value of the number to the nearest multiple of the significance and then applies the negative sign.
Smartsheet Community
community.smartsheet.com › home › get help › formulas and functions
Alternative to FLOOR and CEILING functions - Smartsheet Community
February 7, 2018 - Hi! I'm looking for an alternative for the FLOOR and CEILING functions that I use in Excel. For context, I purchase paper, and buy it in skids and fill the remaining balance in smaller packages. In Excel, I use a formula that references a lookup table to tell me how many sheets of paper come in a skid and how many come in…
Microsoft Support
support.microsoft.com › en-us › office › ceiling-math-function-80f95d2f-b499-4eee-9f16-f795a8e306c8
CEILING.MATH function - Microsoft Support
Copy all of the following table. In a new Excel worksheet, paste it in to cell A1 (and adjacent). If you do not automatically see the Results, select the formula, press F2 and press Enter.
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 - ... Number - the number you want to round. Significance - the multiple to which you want to round the number. For instance, the formula =CEILING(2.5, 2) rounds 2.5 up to the nearest multiple of 2, which is 4.
Exceljet
exceljet.net › ceiling.math function
Excel CEILING.MATH function | Exceljet
September 11, 2021 - Changing the sign of significance has no effect on the result; use mode instead. 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.
Chronicles of Data
chroniclesofdata.com › excel-ceiling-function
How to use the Excel CEILING function - Chronicles of Data
December 11, 2022 - For this example we have listed a variety of values for the significance portion of this calculation directly in the formula: The CEILING function in Excel also works with negative numbers. It won’t round down further into the negatives as it it a function purely based on rounding up, so works in a very similar way to the above whole number examples.
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 - For example, rounding the number ... numbers down with multiples, use the opposite of the CEILING function in Excel and use FLOOR function instead....
TutorialsPoint
tutorialspoint.com › advanced_excel_functions › advanced_excel_compatibility_ceiling_function.htm
Excel - CEILING Function
June 24, 2025 - You may enter the expression "=CEILING(B6,-2)" and press the Enter tab. In this expression, both arguments are negative. If the specified data is non-positive, and the significance is non-negative, the resulting value will round upward close to zero. Write the formula "=CEILING(B7, 3)" in the ...