Forum Discussion
Susan Cooper
Nov 21, 2017Copper Contributor
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...
1 Reply
Sort By
- Hi Susan,
When you say balance, do you want to ROUNDUP?