Forum Discussion

Susan Cooper's avatar
Susan Cooper
Copper Contributor
Nov 21, 2017

How to make a column balance to 1 with (8) decimal places

Trying to balance a sheet in a number value with (8) digits behind the decimal... using sum totals that derived from fractional calculations.  ie... =sum (1/2*3/4*2/3*1/5*1/2).  Continue to get results .99999978 or something. How can I get it to balance? ANY IDEAS...

Resources