Home |
Search |
Today's Posts |
#1
|
|||
|
|||
add 3 non-adjacent % cells visually = 99.9, total shows 100.0
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%. |
#2
|
|||
|
|||
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 a 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 "Chipster" wrote: 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%. |
#3
|
|||
|
|||
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)) "Chipster" wrote: 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%. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I stop text displaying in blank adjacent cells? | Excel Discussion (Misc queries) | |||
Counting empty cells within a range of cells | New Users to Excel | |||
Counting empty cells within a range of cells | New Users to Excel | |||
conditional formatting adjacent cells | Excel Worksheet Functions | |||
I want to format a cell based on an adjacent cells value | Excel Discussion (Misc queries) |