Knowledge Base
Got issues? Don't worry, here are all the solutions.

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
Learn more about Ragic:
Why we created Ragic
User Guide
Ragic Pricing
Keep in touch:
Ragic, Inc.