RE: add 3 non-adjacent % cells visually = 99.9, total shows 100.0
- From: "Jason Morin" <jasonjmorin@xxxxxxxxxxxxxxxxxxxxxx>
- Date: Wed, 18 May 2005 18:21:02 -0700
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
"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%.
.
- References:
- Prev by Date: Re: Date Calculations
- Next by Date: Re: How to export xls file into CSV file
- Previous by thread: add 3 non-adjacent % cells visually = 99.9, total shows 100.0
- Next by thread: RE: add 3 non-adjacent % cells visually = 99.9, total shows 100.0
- Index(es):
Relevant Pages
|
