How to ROUNDUP a SUM?

Options
matthewt
matthewt
edited 10/05/22 in Formulas and Functions

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

  • Mike TV
    Mike TV ✭✭✭✭✭✭
    Answer ✓
    Options

    @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)

Answers

  • Mike TV
    Mike TV ✭✭✭✭✭✭
    Answer ✓
    Options

    @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
    Options

    This is really helpful and fixed the issue.

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

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!