Rounding a range?

  • Thread starter Thread starter Andrew
  • Start date Start date
A

Andrew

Hello all,

I have a situation where I have a template where users
fill out percentages across a row that should total to
1.00 I have a check column on the right, summing the row
to ensure that the percentages total 1

The problem is that the users sometimes use formulas to
enter their percentages so while the actual sum does equal
1.00, the numbers displayed do not.

e.g. in column A-C entering =1/3 will result in a 33.3%
value. My check column, summing columns A-C will show
that the columns equal 100%, but manually summing the
columns will give me a 99.9% (33.3% + 33.3% + 33.3%)

It would be difficult to force the users to use the ROUND
function when entering their percentages - how can I get
the sum of the rounded numbers in my check column????

Thanks for any assistance!
 
One way:

Tools/Options/Calculation, check the Precision as displayed checkbox.

Note however that this is a global setting for the workbook, and may
have unintended consequences if you have other formulae based on hidden
digits.
 
I think that might do the trick.

It's a simple template and shouldn't have any unforeseen
consequences.

Thanks!
 
Back
Top