How to ROUNDUP a SUM?
Hi! I wrote a simple formula to =SUM a few columns into a total.
=SUM(([Column1]@row * [Column2]@row / [Column4]@row))
How do I add the ROUNDUP function with the proper syntax? Right now, without ROUNDUP, the total sum has 4 decimal places and trying to knock that down, either to none, or two max.
I am not a scripting expert, so any assistance is appreciated. Thank you!
Best Answer
-
It's important to understand that ROUND will help you to cut down decimal places so 1.5 will become 2. However with ROUNDUP, 1.4 will also become 2 and 1.1 will also become 2. So I'm guessing that you actually want to use ROUND and not ROUNDUP.
=ROUND(SUM(([Column1]@row * [Column2]@row / [Column4]@row)), 0)
Answers
-
It's important to understand that ROUND will help you to cut down decimal places so 1.5 will become 2. However with ROUNDUP, 1.4 will also become 2 and 1.1 will also become 2. So I'm guessing that you actually want to use ROUND and not ROUNDUP.
=ROUND(SUM(([Column1]@row * [Column2]@row / [Column4]@row)), 0)
-
This is really helpful and fixed the issue.
Thank you for the suggestion and the example, Mike TV! Appreciate it!
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 64.3K Get Help
- 423 Global Discussions
- 221 Industry Talk
- 461 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 144 Just for fun
- 59 Community Job Board
- 462 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 300 Events
- 39 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!