How to ROUNDUP a SUM?

matthewt

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!

Mike TV

@matthewt

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)

Mike TV

@matthewt

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)

matthewt

This is really helpful and fixed the issue.

Thank you for the suggestion and the example, Mike TV! Appreciate it!