Passer au contenu principal


Adaptive Insights French

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