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
Check out the Formula Handbook template!