Reading through the comments it looks like you're on the right track. I don't really use Sheets but when I made one to try what you're doing I found that this bit of code worked just fine for what you're trying. =ROUNDUP((D4-D3) / 5) It still subtracts your cells, then divides by 5, and rounds up like you asked. Hope this helps! Answer from Tarun80 on reddit.com
Google Support
support.google.com › docs › answer › 3093443
ROUNDUP - Google Docs Editors Help
Rounds a number to a certain number of decimal places, always rounding up to the next valid increment. Sample Usage ROUNDUP(99.44,1) ROUNDUP(A2) Syntax ROUNDUP(value,[places]) value
Reddit
reddit.com › r/googlesheets › how to subtract, divide, then round up with a formula in one cell
r/googlesheets on Reddit: How to subtract, divide, then round up with a formula in one cell
October 6, 2024 -
As the title says, I'm trying to subtract the value of one cell from the value of another cell, divide it by a specific number, then round up to the nearest whole number. I've tried different formulas but always end with an error. I've tried the & between formulas, embedding the first formula in parentheses of the last one, but nothing is working.
In the shot below, I need the Find row to have those decimals rounded up:
-
Count shows how many of each color there is
-
Shards shows how much worth the amount of each color has added together (blue = 1, yellow = 2, purple = 5)
-
Total is all the values in Shards combines
-
Need is the target of a value >= of what the Total is
So B6 is simple, I can just subtract the Total from the Need and be done, but dividing by 2 and 5 for C6 and D6 will often give me remainder decimals that I want removed. How do I go about setting up these formulas?
Top answer 1 of 3
2
Reading through the comments it looks like you're on the right track. I don't really use Sheets but when I made one to try what you're doing I found that this bit of code worked just fine for what you're trying. =ROUNDUP((D4-D3) / 5) It still subtracts your cells, then divides by 5, and rounds up like you asked. Hope this helps!
2 of 3
1
u/MaxJacobusVoid Please remember to tap the three dots below the most helpful comment and select Mark Solution Verified (or reply to the helpful comment with the exact phrase “Solution Verified”) to officially close your thread. Applying the “Solved” flair to the post without indicating a solution is actually a violation of the subreddit rules (see rule #6). Thank you in advance for resolving this issue!
Google sheets is automatically rounding a number and I can’t seem to fix it.
Check to see if you've (or someone else) has manually reduced the number of decimal places in that cell to zero. Basically, try increasing the number of decimals two places.
You might just be able to re-apply the "currency" format too, that should correct it if that's what happened. (Format menu > Number > Currency.)
More on reddit.com 4
1
July 12, 2019How to subtract, divide, then round up with a formula in one cell
u/MaxJacobusVoid Please remember to tap the three dots below the most helpful comment and select Mark Solution Verified (or reply to the helpful comment with the exact phrase “Solution Verified”) to officially close your thread. Applying the “Solved” flair to the post without indicating a solution is actually a violation of the subreddit rules (see rule #6). Thank you in advance for resolving this issue! More on reddit.com
11
1
October 6, 2024How to round all cells without using the function ?
Formatting numbers would only 'hide' but not 'change' their true value. For instance, if you babe. 4.6874733636363 and you format it with just two decimal places, it will show up as 4.69 but the true value would still be 4.6874733636363. That may of course affect calculations dependent on this value. If that's okay with you, then you can simply select all values you want to format, and then click that decrease/increase decimal icon on the upper bar (the one that shows 00 with left/right arrow). If you indeed want to have the value be read as 4.69, then you will have to use a ROUNDUP function. Depending on the complexity of the situation, an app script may be needed. More on reddit.com
1
3
January 2, 2023Can you round up without a formula?
Can you not use =ROUNDUP to display the value as you want but have all other formulas pointing to the original cell, which would still be 1.3? More on reddit.com
8
8
December 23, 2015Videos
How to Round Numbers in Google Sheets - 3 Easy Ways to ...
08:10
How to Use All Rounding Functions in Google Sheets | Step-By-Step ...
02:15
How to Round Numbers in Google Sheets - YouTube
11:36
Rounding Numbers in Google Sheets - Comprehensive Guide - YouTube
Round Function in Google Sheets (Round Formula) - YouTube
01:01
How To Round Numbers in Google Sheets | ROUND function explained ...
LiveFlow
liveflow.com › product-guides › how-to-round-numbers-in-google-sheets
How to Round Numbers in Google Sheets
Finally, input a number or refer to a cell containing a number to fill “places” in the formula. This number determines to which digit or decimal the formula rounds up the value.
Google Support
support.google.com › docs › answer › 3093440
ROUND function - Google Docs Editors Help
The ROUND function rounds a number to a certain number of decimal places according to standard rules. Examples Make a copy
The Bricks
thebricks.com › resources › how-to-use-roundup-in-google-sheets-a-step-by-step-guide
How to Use ROUNDUP in Google Sheets: A Step-by-Step Guide
The ROUNDUP function in Google Sheets is a straightforward but powerful tool that does one thing: it rounds a number up to a specified number of decimal places, always moving away from zero. Unlike the standard ROUND function, which rounds to the nearest number (e.g., 5.4 becomes 5, and 5.5 becomes 6), ROUNDUP will always increase the value.
Statology
statology.org › home › how to round up or down to nearest 5 or 10 in google sheets
How to Round Up or Down to Nearest 5 or 10 in Google Sheets
February 2, 2022 - You can use the following formulas to round values to the nearest 5 or 10 in Google Sheets: ... #round value in cell A1 to nearest 5 =MROUND(A1, 5) #round value in cell A1 up to nearest 5 =CEILING(A1, 5) #round value in cell A1 down to nearest ...
Softr
softr.io › google-sheets › formulas › roundup › r › 9tXMLWMdmcKpozQUCsr8JW
How to use Rounds a number to a certain number of decimal places, always rounding up to the next valid increment. Learn more in Google Sheets - Guide
The ROUNDUP rounds a number to a certain number of decimal places, always rounding up to the next valid increment. learn more
Reddit
reddit.com › r/googlesheets › google sheets is automatically rounding a number and i can’t seem to fix it.
r/googlesheets on Reddit: Google sheets is automatically rounding a number and I can’t seem to fix it.
July 12, 2019 -
I have the number “$9.73” in a cell and whenever I click off the cell, it is rounded to $10 but when I click back on the cell, it is back to $9.73. Also, this value is a part of a equation and it has the correct value of $9.73 in the equation but for some reason, it just rounds to $10 when I click off of the cell. Also, I have other numbers in the same column and row as that one and they work perfectly fine. Also, I already tried the TRUNC function, and that does not work either even though I followed two tutorials on two different sites. Any ideas?
Top answer 1 of 3
3
Check to see if you've (or someone else) has manually reduced the number of decimal places in that cell to zero. Basically, try increasing the number of decimals two places.
You might just be able to re-apply the "currency" format too, that should correct it if that's what happened. (Format menu > Number > Currency.)
2 of 3
1
Posting your data can make it easier for others to help you, but it looks like your submission doesn't include any. If this is the case and data would help, you can read how to include it in the submission guide. Thank you.
I am a bot, and this action was performed automatically. Please contact the moderators of this subreddit if you have any questions or concerns.
Google Sheets
sheetshelp.com › sheets help › math › round function – google sheets
ROUND Function - Google Sheets - Sheets Help
January 31, 2024 - The ROUND function in Google Sheets rounds a number to a specified number of decimal places. ... The function uses standard rounding rules, meaning that it rounds positive numbers down if they are below five and up if they are five or above.
Google Support
support.google.com › docs › answer › 3093426
MROUND - Google Docs Editors Help
ROUNDUP: Rounds a number to a certain number of decimal places, always rounding up to the next valid increment.
Spreadsheet Class
spreadsheetclass.com › home › google sheets formulas › all the ways to round numbers in google sheets (round, rounddown, roundup)
All the ways to round numbers in Google Sheets (ROUND, ROUNDDOWN, ROUNDUP)
August 16, 2024 - Since “1.577” is closer to "1.58" than it is to "1.57", the number was rounded up. If the number in cell A2 was "1.573", the formula would have rounded down to "1.57". To round to the nearest tenth in Google Sheets, round to one decimal place with the ROUND function, like this: =ROUND(A2,1)
Quora
quora.com › What-is-the-Google-Sheets-round-up-to-the-nearest-whole-number
What is the Google Sheets round up to the nearest whole number? - Quora
Answer: The function to round up the number to NEAREST whole number is =ROUND(number,0) =ROUND(99.52,0) will give result 100 and =ROUND(99.25,0) will give result 99 The function to round up the number to NEXT whole number is =ROUNDUP(number,0) ...
Superjoin
superjoin.ai › home › blog › how to round up in google sheets
How to Round Up in Google Sheets | Superjoin
August 22, 2024 - This formula sums the values in cells A3 to A7, multiplies the result by 1.07 (adding 7% tax), and then rounds up the total to the nearest whole number. While the ROUNDUP function is the most common method, there are other ways to achieve the same result, depending on your specific needs. The CEILING function is another useful tool in Google Sheets that rounds a number up to the nearest specified multiple.
Kieran Dixon
kierandixon.com › home › how to round in google sheets
How To Round In Google Sheets - Kieran Dixon
July 12, 2021 - STEP 2: Touch the formatting icon above the sheet: STEP 3: Navigate to the 'Cell' tab of the formatting menu, scroll to the 'Decimal places' section, and use the up and down arrows to increase or decrease the decimal places: Here's a clip of ...
Sheetai
sheetai.app › blog › rounding-numbers-google-sheets-guide
How to Round Numbers in Google Sheets
July 27, 2024 - The syntax is ROUND(value, places), ... towards zero, regardless of the next digit. The syntax is ROUNDDOWN(value, places). ROUNDUP: This function rounds a number up, away from zero....
Lifewire
lifewire.com › round-numbers-up-or-down-nearest-5-or-10-3123755
Round Numbers to the Nearest 5 or 10 in Google Sheets
June 8, 2021 - The Google Sheets' MROUND function makes it easy to round a number upward or downward to the nearest 5, 10, or another specified multiple.
Owox
owox.com › blog › articles › ceiling-floor-round-google-sheets
CEILING, FLOOR, ROUND: Google Sheets Functions Guide 2025
October 10, 2025 - The syntax of the CEILING.MATH function in Google Sheets is: ... number: The value to round up to the nearest integer or, if specified, the nearest multiple of significance.
Simular
simular.ai › workflow › how-to-use-round-in-google-sheets-and-excel-guide-fast
How to Use ROUND in Google Sheets and Excel Guide Fast
January 4, 2026 - Prices to 0.99 using ROUND and subtraction. Let the agent open Excel or Google Sheets on your desktop. Have it identify the right columns from headers like Price, Revenue, CPC. Insert or update the correct ROUND, ROUNDUP, ROUNDDOWN, or MROUND formulas.
WPS Office
wps.com › home › blog › office guide › how to roundup numbers in google sheets: a step-by-step guide
How to ROUNDUP Numbers in Google Sheets: A Step-by-Step Guide
September 11, 2025 - For this example, let's consider cell B1 with the number 27.4567 that needs rounding up. Step 3: Select the Formula Bar Click on the formula bar at the top of the Google Sheets window.
Spreadsheet Point
spreadsheetpoint.com › home › google sheets tips › how to round numbers in google sheets (easy formulas)
How to Round Numbers in Google Sheets (5 Easy Methods)
July 27, 2022 - In this tutorial, we showed you how to round numbers in Google Sheets using four different rounding functions in Google Sheets. These included the ROUND, ROUNDUP, ROUNDDOWN, and MROUND functions. The ROUND function can help you round values according to standard rules, while the ROUNDUP function ensures that your values always get rounded upwards.