The problem with my Excel is that I noticed a sum function that gave a clearly incorrect answer. The sum function (red) adds the yellow and blue values, which anyone with 3rd grade math knows is 257.7. However, the result of the function is 253.3 in the red box.
The yellow and blue boxes are summing many rows of numbers themseves, perhaps that has something to do with it?
Help! It's very difficult to work with Excel when I can't trust the results of the functions I run.
http://i91.photobucket.com/albums/k2...sc/problem.jpg
It'd it be easier to diagnose if we saw the actual workbook...
Are you sure that your autocalcs is on... Tools|Options and in Calculation Tab, Automatic should be checked.
Microsoft MVP - Excel
Where there is a will there are many ways. Pick One!
Please read the Forum Rules
If you are happy with the results, please add to the contributor's reputation by clicking the reputation icon (star icon) below
Please also mark the thread as Solved once it is solved. Check the FAQ's to see how.
Preferred Charities: Lupus Canada and Sick Kids Foundation.
Feel Free to Donate if you want to, for the assistance you received today.
Format some additional decimals in AB6 and look at the value.
Microsoft MVP - Excel
Entia non sunt multiplicanda sine necessitate
Yes, I bet it is actually about 126.6....
Microsoft MVP - Excel
Where there is a will there are many ways. Pick One!
Please read the Forum Rules
If you are happy with the results, please add to the contributor's reputation by clicking the reputation icon (star icon) below
Please also mark the thread as Solved once it is solved. Check the FAQ's to see how.
Preferred Charities: Lupus Canada and Sick Kids Foundation.
Feel Free to Donate if you want to, for the assistance you received today.
Ah ha! shg that is it! I'm working off of an excel doccument someone else created and I didn't think of that, great catch!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks