Hi everyone,
I am sure that I must be doing something wrong however I am not sure what it is.
Can you please review the attached macro and explain why I am getting the below answer when the correct answer should be 0.
WorksheetFunction.Sum.error.JPG
Please select range A1 to B11 and then run the macro.
WorksheetFunction.Sum.JPG
Please Login or Register to view this content.
Hi,
It is due to floating point errors. You will see the same result if you enter =SUM(A1:A2,B9:B10) into a cell on the worksheet and show enough decimal places.
Don
Please remember to mark your thread 'Solved' when appropriate.
Thank you, because of the explanation i am able to modify to the below.
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks