Real file has almost three thousand records where formula in Col B should show "FALSE" if the five daily totals in Cols D - H do not match the weekly total in Col C.
=C3=SUM(D3:H3)
For some reason nine of them are saying the totals do not match when they do.
All clarifications welcome, because I can't explain to the End User why this is happening, and (obviously) they are not happy at false "Error Messages" being generated.
Ochimus
quote from Wiki:
"Although Excel can display 30 decimal places, its precision for a specified number is confined to 15 significant figures"
You have to ROUND values before comparing.
20 decimals
Formula:
Please Login or Register to view this content.
still give you false
but
13 decimals
Formula:Please Login or Register to view this content.
give you true.
As I see it is about days or hours, If I am not mistaken seconds needs 6 decimals, so rounding into 13 I think is enough precision.
Happy with my answer * Add Reputation.
If You are happy with solution, please use Thread tools and mark thread as SOLVED.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks