View Single Post
  #2   Report Post  
Jason Morin
 
Posts: n/a
Default

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%.