Skip to main content

logoCorrectSize.png

Adaptive Insights LLC.

How to Round to Any Decimal Place

By default the solution rounds data to the 9th decimal place, regardless of the number of decimal places set on an account.  There is a formula called Round that you can use, but unlike Excel it does not have a parameter for what to round to so it only rounds to the whole number.  This article covers a trick for rounding to any decimal place up to the 8th position.

The trick is to multiply the number before rounding, then divide it by the same value after rounding.  The table below illustrates the concept.

Acct.MyValue = 50.532698415

clipboard_e3c97d1529660710dc1865193f42dd0dd.png