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.
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.
Videos
Excel Tips
excel.tips.net › T002152_Establishing_a_FLOOR_and_CEILING.html
Establishing a FLOOR and CEILING - Microsoft Excel Tips
June 1, 2024 - Unlike other rounding functions, however, FLOOR and CEILING work with multiples of numbers. For instance, consider the following formula: ... This formula will return a value of 24. Why? Because 24 is the largest multiple of 12 between 27 and 0. The CEILING function works similarly, as follows:
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 July 13, 2020
YouTube
youtube.com › watch
CEILING, FLOOR, ROUND Functions in Microsoft Excel - YouTube
Discover how to use the functions: CEILING, FLOOR and ROUND in excel. Follow along the series to learn every relevant excel function that will boost your pro...
Published March 5, 2023
ExcelFind
excelfind.com › excel-functions › excel-ceiling-function
How to use the Excel CEILING function - ExcelFind.com
February 12, 2024 - The Excel FLOOR function rounds numbers down to the nearest multiple of significance, useful for inventory and budget control. The Excel CEILING.MATH function rounds numbers up to the nearest integer or multiple, versatile for financial 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 - FLOOR is a function that rounds a number down to the nearest integer, while CEILING rounds a number up to the nearest integer. ... Written by Signe on 7/15/25. Posted in 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.
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
Syntax: CEILING.MATH(number, [significance], [mode])
YouTube
youtube.com › watch
CELING.MATH and FLOOR.MATH Function Tutorial in Excel - YouTube
This video explains the use of CEILING.MATH and FLOOR.MATH functions in Microsoft Excel. These functions are used for rounding up and down a number to the ne...
Published September 29, 2025