Just do ROUNDUP((B5/36)*1.1,0)... Does the Roundup but all in one column Answer from sultav on reddit.com
Microsoft Support
support.microsoft.com › en-us › office › round-function-c018c5d8-40fb-4053-90b1-b3e7f61a213c
ROUND function - Microsoft Support
To always round up (away from zero), use the ROUNDUP function. To always round down (toward zero), use the ROUNDDOWN function. To round a number to a specific multiple (for example, to round to the nearest 0.5), use the MROUND function. Copy the example data in the following table, and paste ...
Microsoft Support
support.microsoft.com › en-us › office › round-a-number-to-the-decimal-places-i-want-in-excel-49b936f9-6904-425d-aa98-02ffb7f9a17b
Round a number to the decimal places I want in Excel - Microsoft Support
Use a positive number here to round the number to the number of decimal points you specify. The same thing applies to the next two formulas that round to hundredths and thousandths. ... Round a number up by using the ROUNDUP function. It works just the same as ROUND, except that it always rounds ...
excel - How to roundup a number to the closest ten? - Stack Overflow
Probably the title is not very suggestive. Let me explain you with an example. I have: 12345.6 2345.1 12345.00000001 I want those numbers to be roundup to 12350. How can I do this? If possible... More on stackoverflow.com
How to use Roundup function within an existing formula
Hi, I have a formula in a cell which contains 2 parts. The first part is what i need to be rounded up. This formula is in cell K8. I need to answe... More on myonlinetraininghub.com
6
July 7, 2024How do I make a cell round up a value automatically on a calculated formula?
u/ieatpeaches - Your post was submitted successfully. Please read these reminders and edit to fix your post where necessary: 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 Once your problem is solved, reply to the answer(s) saying Solution Verified to close the thread. 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
8
9
June 24, 2021How do I round after a calculation within the same cell
u/Particular_Ganache - 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
11
3
November 23, 2022Videos
How to ROUNDUP in Excel - YouTube
07:01
Using the Excel ROUND Functions - YouTube
01:00
Round numbers with the ROUND function in Excel - YouTube
03:39
Excel How to Round to N Digits or Multiples - YouTube
04:41
Excel: How to Round using ROUND(), ROUNDUP() and ROUNDDOWN() ...
Reddit
reddit.com › r/excel › how do i make a cell round up a value automatically on a calculated formula?
r/excel on Reddit: How do I make a cell round up a value automatically on a calculated formula?
June 24, 2021 -
Hello Everyone,
I'm trying to make a calculator for our customers, where they type their square footage, and then the different options I have spits out the number of boxes they need to buy.
Since our product is sold by the carton, I need it to round up.
So the customer enters their footage, and in my cell I have it take that square footage, divide by the square footage per box, then multiply by 1.10 to factor waste.
For example, they enter 1150 in cell B5, their total square footage. Our product comes 36 square feet per box, so in the cell next to that product I have =(B5/36)*1.1 which equals 35.1388888.
Is there anyway I can set it so it rounds up that 35.138888 to 36? Changing the number function makes it round down or up. I need it to round up no matter what. I would like to get away without using the =ROUNDUP function, since it makes the spreadsheet look messy because I need 2 columns, the raw value, 35.13888, then the column next to it the ROUNDUP function. I guess I could hide the math portion in some other cell somewhere, but would like to avoid having to do that since it'll make editing this in the future a pain.
Thanks!
Career Principles
careerprinciples.com › resources › excel-roundup-function
Excel ROUNDUP Function (With Examples) | Career Principles
January 15, 2025 - To use the ROUNDUP function in Excel, click into a cell and type in =ROUNDUP to initiate the function. Next, you’ll see 2 input prompts for “number” which is the number you want to round up and “num_digits” which is the number of digits ...
Quora
quora.com › How-can-you-round-up-or-down-a-value-in-Excel-without-using-VLOOKUP-IF-and-other-formulas
How to round up or down a value in Excel without using VLOOKUP, IF and other formulas - Quora
Answer (1 of 2): =ROUNDUP, =ROUNDDOWN and =ROUND are all great formulas that will round to the nearest n places before or after the decimal. =MROUND will round to the nearest multiple of a specified integer (i.e. nearest 5, instead of nearest 10). But you’d like do do it without a formula. If ...
IONOS
ionos.com › digital guide › online marketing › online sales › excel: roundup
How to round up in Excel - IONOS
October 10, 2024 - In Excel, formulas always begin with an equals sign. Close · After double-clicking on the function, you can enter the parameters in the Excel function for rounding up. Click on Enter to carry out the ROUNDUP function. You should now see the result displayed in the cell.
Top answer 1 of 4
28
You could also use CEILING which rounds up to an integer or desired multiple of significance
ie
=CEILING(A1,10)
rounds up to a multiple of 10
12340.0001 will become 12350
2 of 4
25
Use ROUND but with num_digits = -1
=ROUND(A1,-1)
Also applies to ROUNDUP and ROUNDDOWN
From Excel help:
- If num_digits is greater than 0 (zero), then number is rounded to the specified number of decimal places.
- If num_digits is 0, then number is rounded to the nearest integer.
- If num_digits is less than 0, then number is rounded to the left of the decimal point.
EDIT:
To get the numbers to always round up use =ROUNDUP(A1,-1)
Top answer 1 of 2
2
Like Andrew said, you can place the multiplication formula within the =ROUNDUP formula.
Something like=ROUNDUP((F4*0.54),0) would do the trick.
2 of 2
0
Generally speaking, any time you reference a cell in a formula that has a formula too, you can instead insert the formula from that cell into the referencing formula.
That is, in this case: =roundup(f4*0.54,0)
Since the formula =f4*0.54 is in D4, you replace the D4 in =roundup(D4,0) with everything except the = (f4*0.54).
Excel Tip
exceltip.com › home › other q&a formulas
Rounding Numerical Calculation Results In Microsoft Excel
November 16, 2019 - I have a formula like this =(($H2/50)*0.15)*100 How can I round it up? ... Hi, Anne if you want to round up the result to zero number of decimal points, use this formula. Use ROUNDUP((($H2/50)*0.15)*100,0).
DataCamp
datacamp.com › tutorial › excel-round
Excel ROUND(): The Complete Guide to Rounding in Excel | DataCamp
April 25, 2025 - ... There are different variations of the Excel ROUND() function, each with a specific use. The ROUNDUP() function always rounds away from zero, regardless of the digits that follow. This means the result is always greater than the original number, ensuring a conservative approach in calculations.
Excel Forum
excelforum.com › excel-formulas-and-functions › 490157-how-do-i-round-up-a-result-of-a-formula-in-excel.html
how do I round up a result of a formula in Excel
Hi, Make your formula to be a part of the roundup formula as follows: =ROUNDUP(the formula you have now without the leading "=" sign,number of digits you want the result to be rounded up) For example, if your formula is =A2^3+B2^2+C2, the new formula would be =ROUNDUP(A2^3+B2^2+C2,0); the result ...
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 - To round up to nearest integer, use an Excel ROUNDUP formula with num_digits set to 0. For example =ROUNDUP(5.5, 0) rounds decimal 5.5 to 6. To round down to nearest whole number, use either INT or ROUNDDOW with num_digits set to 0. For example ...
Corporate Finance Institute
corporatefinanceinstitute.com › home › resources › roundup excel
Excel ROUNDUP - Formula, Example, Template, How to Use
April 30, 2024 - In this session, we will show you how to round a number up in Excel using the =ROUNDUP() function. This formula will be a major help in saving you time when performing financial modeling and will also improve your accuracy in Excel.
Excel Insider
excelinsider.com › home › our blog › excel pro tips › how to roundup a formula result in excel (6 easy ways)
How to Roundup a Formula Result in Excel (6 Easy Ways) - Excel Insider
July 2, 2025 - ➤ To round up the result of a formula, select a helper cell and enter the following formula: =ROUND(E14,2) ➤ Replace E14 with the cell reference of your formula result. Instead of 2, you can enter the number of digits to which you want to ...
My Online Training Hub
myonlinetraininghub.com › excel-forum › excel › how-to-use-roundup-function-within-an-existing-formula-1
How to use Roundup function within an existing formula • General Excel Questions & Answers • Excel Forum
July 7, 2024 - You can use the ROUND or ROUNDUP functions, more about those functions in this blog article How to round numbers in Excel. Check attached file for an example. ... I have tried the Roundup within the formula but it doesn't seem to work. I get a notification saying I've entered too few arguments for this function. This is what I tried: ((((ROUNDUP(C5*(D5/100)); 0) - SUM(F6:J7))) Please advise. ... That worked! Thank you so much! ... No worries. ... Please Login or Register to reply to this topic. ... Currently viewing this topic 4 guests. ... More results...
Quora
quora.com › How-do-I-roundup-a-formula-result-in-Excel
How to roundup a formula result in Excel - Quora
Answer (1 of 3): Use the formula =round(n,d) where: * n is the number to be rounded * d is the number of digits to show to the right of the decimal point This function will round up if the decimal places value is greater than or equal to 0.5 ...
Dummies
dummies.com › article › technology › software › microsoft-products › excel › formulas-for-rounding-numbers-in-excel-148985
Formulas for Rounding Numbers in Excel | dummies
July 3, 2025 - Entering a 0 as the second argument tells Excel to remove all decimal places and round the integer portion of the number based on the first decimal place. For instance, this formula rounds to 94:
O'Reilly
oreilly.com › library › view › microsoft-r-excel-r-2010 › 9780735665064 › ch16s48.html
ROUNDUP() - Microsoft® Excel® 2010 Formulas & Functions Inside Out [Book]
December 22, 2011 - Background. Unlike ROUND(), the ROUNDUP() function always rounds a number up. The num_digits argument indicates the number of decimal places to round the number. If the value of num_digits is: Greater than zero, the number is rounded up to the ...
Author Helmut Reinke Egbert Jeschke Sara Unverhau, Eckehard Pfeifer, Bodo Fienitz, and Jens Bock
Published 2011
Pages 1088
Lifewire
lifewire.com › combine-round-and-sum-functions-in-excel-4178187
Here is How to Easily Combine the ROUND and SUM Functions in Excel
August 8, 2022 - It's a similar formula, except ignore "SUM" and use "*" to multiply cells. It should look something like this: =ROUNDUP(A2*A4,2). The same approach can also be used for rounding other functions like cell value averages.