About Us

PSmith

Excellent, thank you!

"Nigel" wrote:

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.

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
how to get a text/letters to equal to a percentage	jose l.	Excel Worksheet Functions	5	June 1st 09 02:10 PM
checking if two arrays are equal	Knox	Excel Programming	3	June 1st 06 05:56 PM
Checking if not equal	Kaak[_12_]	Excel Programming	0	June 27th 05 10:03 AM
Checking if not equal	jpizzle[_10_]	Excel Programming	1	June 27th 05 10:00 AM
lower and upper case equal on spreadsheet but not equal in VB	don	Excel Programming	2	March 13th 05 12:04 AM

Menu

About Us