Ragic Logo
<< My import file might have duplicates. How do I prevent from importing everything twice?Table of ContentsWhat happens when I try to save the same value with the unique setting checked? >>

Rounding numbers to the nearest two decimal points

Ragic's ROUND formula will round a number to the nearest integer.

Ragic's number formatting options, such as #,####.## and #,####.00 would actually display the decimal points rounded, but will store the numbers with their actual decimal values.

If you're looking to round to the nearest two decimal points, as is found with currency or other financial transactions, you are most likely looking to calculate according to the nearest 2 decimal places, which would be the nearest cent for the resulting sum to be accurate.

An example for a workaround that will have Ragic store numbers rounded to the nearest two decimals is shown below:

Original formula that needs to be rounded: A1/4

Suggested formula: ROUND(A1*100/4)/100

Top of Page
<< My import file might have duplicates. How do I prevent from importing everything twice?Table of ContentsWhat happens when I try to save the same value with the unique setting checked? >>
Learn more about Ragic:
Why we created Ragic
Webinars
User Guide
Keep in touch:
Blog
Email
Facebook
Twitter
Ragic, Inc.
1-888-666-8037
Terms
Privacy