Knowledge Base
How can we help?

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
Webinars
User Guide
Ragic Pricing
Applications
Keep in touch:
Blog
Facebook
YouTube
Ragic, Inc.
1-888-666-8037
Terms
Privacy
info@ragic.com