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?
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.comRound up to the nearest $9.99
How to round up currency? - Google Sheets
How to sum a column and round up at the same time
Videos
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?
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.)
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.
