How can we help?
Full Site Search

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

    Start Ragic for Free

    Sign up with Google