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
- Customer Resources
- 64.9K Get Help
- 441 Global Discussions
- 139 Industry Talk
- 472 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 68 Community Job Board
- 496 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!