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
Excel for Microsoft 365 Excel for Microsoft 365 for Mac Excel for the web Excel 2024 Excel 2024 for Mac Excel 2021 Excel 2021 for Mac Excel 2019 Excel 2016 · This article describes the formula syntax and usage of the CEILING function in Microsoft Excel.
Corporate Finance Institute
corporatefinanceinstitute.com › home › resources › ceiling function
CEILING Function - Formula, Calculate, Example, Sample
June 19, 2025 - The CEILING function rounds incoming values up to a given multiple of n. Essentially, the CEILING function counts by a given multiple of n. The count shown above in column G is then divided by n, that is in this case =3. Lastly, the ISEVEN function is used to force a TRUE result for all even row groups, which triggers the conditional formatting. ... If we are using MS Excel 2007 or earlier versions, provide the significance argument with a different arithmetic sign from the given number argument.
Videos
02:04
CEILING and FLOOR Excel Functions (with examples) - YouTube
03:28
Excel Floor and Ceiling Functions - YouTube
04:35
How to Roundup Numbers using CEILING function in Excel 2016 - YouTube
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
MyExcelOnline
myexcelonline.com › home › the ultimate guide to ceiling function in excel
The Ultimate Guide to Ceiling Function in Excel | MyExcelOnline
January 26, 2025 - By using the formula =CEILING(A1, 1) - 0.01, I can convert any number in cell A1 to a price that ends in .99. This strategy can stimulate purchases because prices ending in .99 tend to give the impression of a bargain.
LiveFlow
liveflow.com › product-guides › ceiling-math-function-in-excel-explained
CEILING.MATH Function in Excel: Explained
These are just a few examples of how the CEILING.MATH function can be utilized in Excel. Its ability to round up values to specific multiples makes it a valuable tool in various fields, including finance, time management, inventory control, and data analysis. ... "Mode" is an optional argument that specifies how rounding should occur. It can take the values -1, 0, or 1. Let's use an example to understand the CEILING.MATH function better. Suppose we have the following formula in Excel:
Exceljet
exceljet.net › ceiling function
Excel CEILING function | Exceljet
September 11, 2021 - This formula depends on the CEILING function , which rounds numbers up to a given multiple. It works because of how dates work in Excel's default 1900 date system, where the first day is the number 1, which is Sunday, January 1, 1900. In this scheme, the first Friday is day number 6, the second... The Excel CEILING function rounds a number up to a given multiple. The multiple to use for rounding is given as the second argument ( significance ).
ExcelFind
excelfind.com › excel-functions › excel-ceiling-function
How to use the Excel CEILING function - ExcelFind.com
February 12, 2024 - Assuming A2 contains a time in hours, this formula rounds it up to the nearest half-hour. CEILING is commonly used in financial, engineering, and construction scenarios. It’s important to note that CEILING always rounds numbers up, even if the number is already a multiple of the significance. The function can handle both positive and negative numbers, but the sign of the significance should match the sign of the number for expected results. The Excel ...
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.
Automate Excel
automateexcel.com › home › ceiling function – round to multiple in excel, vba, g sheets
CEILING Function - Round to Multiple in Excel, VBA, G Sheets
November 7, 2023 - To round time up to a certain increment, just enter your desired unit of time using quotations. Here we will round up to the nearest 15 minutes. ... Excel / Google Sheets contains many other round functions. Here are quick examples of each: ... Below, we will point out a few functions in particular. The FLOOR and MROUND Functions work exactly the same as the CEILING Function, except the FLOOR Function always rounds down and the MROUND Function always rounds to the nearest multiple.
Chronicles of Data
chroniclesofdata.com › excel-ceiling-function
How to use the Excel CEILING function - Chronicles of Data
December 11, 2022 - The syntax for this formula is quite simple – we just need to wrap the time in double quotes. See below examples: Now that we have seen some examples of the Excel CEILING formulas and expected outputs, lets have a quick look at some of the more common errors that we can come across with this ...
TechOnTheNet
techonthenet.com › excel › formulas › ceiling.php
MS Excel: How to use the CEILING Function (WS)
This Excel tutorial explains how to use the Excel CEILING function with syntax and examples. The Microsoft Excel CEILING function returns a number rounded up based on a multiple of significance.
Formula Bot
formulabot.com › excel › ceiling-function
CEILING Excel Formula - Function, Examples, How to Use
The HOUR function extracts the hour from a time serial number in Excel, aiding in time analysis and calculations. ... The HSTACK function combines multiple arrays side by side, enhancing data organization and analysis in Excel. ... The HYPERLINK formula creates clickable links in Excel, enabling quick access to web pages or documents directly from the spreadsheet.
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 - It has the same syntax as the FLOOR function. ... 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, ...
SimonsezIt
simonsezit.com › article › ceiling-function-in-excel
How to Use the CEILING Function in Excel? A Step-by-Step Guide
May 19, 2025 - The Excel CEILING function can ... in the Formulas main menu ribbon under the name =CEILING.MATH. Rounding up a number to the multiples of the significant digits using the CEILING function can be used in a variety of places. In this article, we saw how to use the CEILING function in Excel. We also saw 2 different ways to use the function along with its use cases. Please visit our free resources center for more high-quality ...
Microsoft Support
support.microsoft.com › en-us › office › ceiling-math-function-80f95d2f-b499-4eee-9f16-f795a8e306c8
CEILING.MATH function - Microsoft Support
Excel for Microsoft 365 Excel for Microsoft 365 for Mac Excel for the web Excel 2024 Excel 2024 for Mac Excel 2021 Excel 2021 for Mac Excel 2019 Excel 2016 · Here is the formula syntax and use of the CEILING.MATH function in Microsoft 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.
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 - Excel’s CEILING function round numbers up to the nearest multiple. It’s useful in setting prices, currency conversion, rounding employee’s work time, and more.
Better Solutions
bettersolutions.com › excel › functions › ceiling-math-function.htm
Excel CEILING.MATH Function - BetterSolutions.com
Microsoft Excel · Functions · CEILING.MATH · Maths & Trigonometry · Complete List · Alphabetical - C · Index - C · Updated: 01 March 2026 · 01 March 2026 · © 2026 Better Solutions Limited. All Rights Reserved.
Sturppy
sturppy.com › formulas › ceiling-math-excel-formula
CEILING.MATH: Excel Formulas Explained
Using CEILING.MATH is easy. Here's the basic syntax: ... The "number" argument is the cell or value you want to round up. The "significance" argument is the multiple to which you want to round up. For example, if you want to round up to the nearest 10, you would use 10 as the significance. Let's say I have a list of prices for products I sell: In this example, I want to round up all prices to the nearest dollar.
ExtendOffice
extendoffice.com › excel tips › excel functions › excel ceiling function
Excel CEILING function
For instance, =CEILING.MATH(-10.12,0.2,1)returns -10.2, =CEILING.MATH(-10.12,0.2,0)returns -10 · Excel CEILING.PRECISE The CEILING.PRECISEfunction rounds number up to nearest integer or nearest multiple, it ignore sign of number, round number always up. Round number to nearest 5,10, 50 or 100 number in Excel This article provides some simple formulas ...