LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
Kay Kay is offline
external usenet poster
 
Posts: 129
Default Conflicting Calculations

Hello all,

I have audited my formulas over and over and am seeing an odd behaviour in
Excel 2007 SP2. I am comparing cost rates. One contract price will be
0.0140 per minute.Another contract price will be 0.0159.

Each will be compared against the same minute field. Obviously, if you
multiple the first contract price by the minute it will be less than the
second contract price. However, when you add both columns up to get a total
of about 40,000 records, the second contract amount totals less than the
first contract amount. Impossible, right? I even tested with a sumrpoduct
and received the same results. I selected each column, separately and looked
at the auto-calculate value. Once again the larger contract price shows the
smaller total. Can anyone explain.
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Permutations with conflicting groups tomm tomm Excel Discussion (Misc queries) 1 January 28th 10 02:18 AM
Conflicting vlookups Bruister via OfficeKB.com Excel Worksheet Functions 1 October 17th 09 04:57 PM
Conflicting results in formulas? mikelee101[_2_] Excel Worksheet Functions 4 March 26th 08 02:50 AM
Conflicting Conditional Formatting LMcK Excel Discussion (Misc queries) 1 March 1st 06 08:15 PM
Conflicting date ranges Darknexxus Excel Worksheet Functions 0 October 4th 05 04:37 AM


All times are GMT +1. The time now is 05:21 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"