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!

Find more posts tagged with

Accepted answers

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)

All comments

Mike TV

@matthewt

=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!

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.