Thread
:
Checking if the sum of a percentage is equal to one
View Single Post
#
2
Posted to microsoft.public.excel.programming
Nigel[_2_]
external usenet poster
Posts: 735
Checking if the sum of a percentage is equal to one
floating point arithmetic is the issue -- take a look here
http://support.microsoft.com/kb/78113
--
Regards,
Nigel
"PSmith" wrote in message
...
Have a bit of a problem here.
Here's a sample sheet where I have reproduced my problem:
http://pbsmith.iweb.bsu.edu/percentageSum.xls
(you will need have macros
enabled, as this is a VBA subroutine)
I have 2 columns, where the individual percentages are added together. I
have a "Grand total" which adds up the individual totals. I do a check
against the grand total to make sure it's equal to one (using .Range() <
1)
The problem is if there are 10 values of 10%, this check fails.
If you replace one of the 10% values with two 5% values, the check
succeeds
(as it should, as long as it still adds up to 100%).
I'm using Excel 2007. Any feedback on this problem would be greatly
appreciated; I'm at a bit of a loss myself.
Reply With Quote
Nigel[_2_]
View Public Profile
Find all posts by Nigel[_2_]