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.
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 ... 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 ...
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, 2024"What is the result of the Excel formula “=CEILING(19,4"
The FLOOR function in MS Excel is used for rounding down a given number to the nearest multiple of the given significance. The syntax of FLOOR is '=FLOOR(number, significance)'. The CEILING function in MS Excel is used for used for rounding up a given number to the nearest multiple of the given ... More on testbook.com
1
1707
January 19, 2023Adding Ceiling formula to existing formula in the same cell
hey gurus, I'm very new to excel and only use it about once a year when my annual price increase takes effect, but I'd like to learn more outside of the issue I'm having so this will be great resource I'm sure. I receive a spreadsheet from my vendors with the new pricing for the year, it has formulas aleady built in to price for my markup. What I wish to do is input a ceiling ... More on excelguru.ca
3
January 11, 2021excel - How to add multiple rules for Ceiling formula? - Stack Overflow
I have a problem in Excel where I want to use a formula to calculate the number of delegates a specific county can send to the regional congress. In this case a county is allowed to send 1 delegate per 300 votes (1-299: 1, 300-599: 2 etc.) Thus for this case I used the Ceiling formula which ... More on stackoverflow.com
Videos
03:22
How to use the Ceiling Function in Excel - YouTube
02:04
CEILING and FLOOR Excel Functions (with examples) - 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
Exceljet
exceljet.net › ceiling function
Excel CEILING function | Exceljet
September 11, 2021 - For more control over how CEILING rounds negative numbers, see the CEILING.MATH function. 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.
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.
Microsoft Support
support.microsoft.com › en-us › office › ceiling-precise-function-f366a774-527a-4c92-ba49-af0a196e66cb
CEILING.PRECISE function - Microsoft Support
The absolute value of the multiple is used, so that the CEILING.PRECISE 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 worksheet. For formulas to show results, ...
LiveFlow
liveflow.com › product-guides › ceiling-math-function-in-excel-explained
CEILING.MATH Function in Excel: Explained
The CEILING.MATH function in Excel is used to round a number up to the nearest specified multiple. It is an updated version of the CEILING function, introduced in Excel 2013.
Microsoft Support
support.microsoft.com › en-us › office › ceiling-math-function-80f95d2f-b499-4eee-9f16-f795a8e306c8
CEILING.MATH function - Microsoft Support
Using the significance and mode arguments, you can change the direction of the rounding for negative numbers. For example, rounding -6.3 to a significance of 1 with a mode of 1 will round away from 0, to -7. Combinations of Significance and Mode values can affect rounding of negative numbers ...
Wall Street Oasis
wallstreetoasis.com › home › free › learn excel › excel functions › ceiling function
Excel CEILING Function - Formula, Examples, Advanced Rounding | Wall Street Oasis
December 10, 2024 - In the first example, in row 3, we wanted to round $4.50 up to the nearest dollar, so we use the =CEILING(number, significance) formula to calculate it by using $4.50 in B3 as the number, and 1 for the importance and it got us $5 for the answer ...
Formula Bot
app.formulabot.com › excel › ceiling-function
CEILING Excel Formula - Function, Examples, How to Use
Learn how to use the CEILING function in Excel to round numbers up to the nearest specified significance for accurate calculations.
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 - Select the cell in which you would like the result of the ceiling function to appear. Enter the following formula in the selected cell: =CEILING(number, significance).
SimonsezIt
simonsezit.com › article › ceiling-function-in-excel
How to Use the CEILING Function in Excel? A Step-by-Step Guide
May 19, 2025 - To use the CEILING function, choose a destination cell and enter the formula =CEILING(number,significance). Here, the number value represents the number value to be rounded and significance represents the multiples to which the numerical values ...
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 ...
Bizinfograph
bizinfograph.com › home › general › how to use ceiling function in excel? easy guide.
How to use CEILING function in Excel? Easy Guide.
January 31, 2024 - In cell D2, this formula rounds the value 12.34 up to the nearest multiple of 5, resulting in 15. Similarly, all remaining cell’s value is rounded up. The CEILING function is applied to each corresponding pair of values from columns A and B, allowing us to round the numbers up to the specified multiples and generate the results in column C. This is just one basic example of how the CEILING function can be used in Excel for rounding up numbers as per specific requirements.
Excelguru
excelguru.ca › home › forums › general excel help › formulas
Adding Ceiling formula to existing formula in the same cell | Excelguru Forums
January 11, 2021 - Pecoflyer, I'm not sure where you mean to put that? Would it go in the retail cell formula? or would it go in the formula that the retail cell references to? ... =CEILING(IF(ISBLANK(Q8),"",Q8/$Q$1),5) and that longish formula you mentioned can be shortened to: =1-L12/100
Stack Overflow
stackoverflow.com › questions › 72866586 › how-to-add-multiple-rules-for-ceiling-formula
excel - How to add multiple rules for Ceiling formula? - Stack Overflow
the picture shows some sample data, and for example, D8 I can use the simple Ceiling formula, but for D5 with over 3000 voters, I want a formula that calculates amount of Delegates per 3000 votes + amount per extra 1000 votes. ... May be IF() function can help. Post few sample data then desired output and post your current formula. ... the formula Im using for the Delegate per 300 vote is: =AVRUND.GJELDENDE.MULTIPLUM.OPP.MATEMATISK([@[Total amount votes]]/300) ( the norwegian translate for round up in excel)
Sturppy
sturppy.com › formulas › ceiling-math-excel-formula
CEILING.MATH: Excel Formulas Explained
CEILING.MATH is an Excel formula that rounds numbers up to a specified multiple. For example, if you have a list of numbers and you want to round them all up to the nearest 10, CEILING.MATH can do that for you.
MyExcelOnline
myexcelonline.com › home › the ultimate guide to ceiling function in excel
The Ultimate Guide to Ceiling Function in Excel | MyExcelOnline
January 26, 2025 - If we’re looking at items bundled in groups of 5, and I need a total of 23 items, the formula =CEILING(A2, B2) will tell me exactly how many bundles to round up to. It simplifies order and inventory planning, ensuring businesses purchase or ...
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 - The CEILING function tells Excel to round the number 11 up to the nearest multiple of 2. ... Hope that explains how the CEILING function works. The CEILING function can be used in financial analysis.
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 - The CEILING function in Excel can be used to round the prices to the nearest 25 cents multiple too. Using the same Product Gizmo 001, the CEILING formula in Excel =CEILING(14.671,.25) (see Cell D2) rounds the number UP to the nearest multiple of 25 cents or CA$.25.