add 3 non-adjacent % cells visually = 99.9, total shows 100.0

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Formula in cell N34 adds N16 (11.1%), N24 (44.4%), and N31 (44.4%). The
total displayed in N34 is 100.0%, should be 99.9%.
 
You're seeing 99.9% because your values are not 11.1%, 44.4% and 44.4%
exactly. There is more there than you see. If the values are:

11.14%
44.43%
44.44%

Then the true sum is 100.01%. If formatted to the tenth decimal place,
you'll see 100.0%.

HTH
Jason
Atlanta, GA
 
Adding a little to Jason's response, if you want the values in N16, N24, &
N31 to be just what they appear to be, apply the Round() function to them,
rounding them to 3 decimal places.

If the values were in contiguous cells you could , use an array formula,
committed by pressing Ctrl-Shift-Enter:

=SUM(ROUND(A1:A3,3))
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

2 Columns total division 4
finding values and displaying adjacent values 1
Counting Consecutive Months in Top Third 1
Cell value when conditions are met 8
Annotations sticking to data point & data table 4
Adding data only if adjacent to cell labeled "male"/"female" 1
Averages 1
Total a column contingent upon the cell to the right being non-bla 3

Back
Top