Author |
Message |
D11
Elite Baiter
Joined: 02 Jul 2006
Posts: 1702
|
Posted:
Mon Jul 30, 2007 7:34 am |
|
Code: |
=SUM(BT58)+BT54+BT42+BT24 |
Value of BT58 = 27
Value of BT54 = 3
Value of BT42 = 30
Value of BT24 = 7
Now my brain tells me thats easy total = 67, however excel says the total for those 4 cells is 69
There straight numbers not sums of sums so a "circular" calculation isnt occuring. I spotted it in my order forms for 69 units and im like "eh? we never order 69 units" Seems excel 2007 really cant add up correctly.
Now its obvious why i noticed the total, our offices made a right laugh of the number itself. Anyone else getting weird sums with 2007? |
_________________
1x 0x
Click here to support 419Eater.com
I make software that drives lads crazy. Thats my revenge on lads. (it all helps)
this transaction is 100 percent risk/hitch free - bobo
why no pay me - abum bello
because the cops will know it was you - me
ok this is good - abum bello |
|
|
|
Zorro
419Eater is my life
Joined: 01 Feb 2007
Posts: 377
Location: In levitation
|
Posted:
Mon Jul 30, 2007 7:39 am |
|
did you try typing the formula thus --> =BT58+BT54+BT42+BT24 |
_________________ Begin at the beginning and go on till you come to the end; then stop
There is one way to find out if a man is honest; ask him! If he says yes, you know he's crooked.
The only reason for time is so that everything doesn't happen at once. |
|
|
|
D11
Elite Baiter
Joined: 02 Jul 2006
Posts: 1702
|
Posted:
Mon Jul 30, 2007 7:43 am |
|
Yup same result 69.
I rang microsoft but there not open till 9am this morning so ill find out soon why it dont work lol.
ive also searched the knowledge base and googled it. |
_________________
1x 0x
Click here to support 419Eater.com
I make software that drives lads crazy. Thats my revenge on lads. (it all helps)
this transaction is 100 percent risk/hitch free - bobo
why no pay me - abum bello
because the cops will know it was you - me
ok this is good - abum bello |
|
|
|
Zorro
419Eater is my life
Joined: 01 Feb 2007
Posts: 377
Location: In levitation
|
Posted:
Mon Jul 30, 2007 7:46 am |
|
That's really curious D1. Do post your findings here please |
_________________ Begin at the beginning and go on till you come to the end; then stop
There is one way to find out if a man is honest; ask him! If he says yes, you know he's crooked.
The only reason for time is so that everything doesn't happen at once. |
|
|
|
thud419
Baiting Guru
Joined: 04 Jan 2006
Posts: 3193
|
Posted:
Mon Jul 30, 2007 8:28 am |
|
You might try changing the cell properties on BT58, BT54, BT42 and BT24 to show a couple of decimal places. 27.4 + 3.4 + 30.4 + 7.4 = 68.6 or 69
But I wouldn't expect order quantities to be fractional. |
_________________ Click here to feel warm and cozy.
I did not f**k your wife in any way -- Nike Akanbi
I don't know what else to do or do I continue filling and filling forms. -- Barr. Koloti
you has been dribbling me up and down but I will show some thing you have never seen before, I think you breath air wait and see. -- Barr. Cole
x14
x 0.25 won from Reaper in a sucker's bet
x8 x several |
|
|
|
shuntbuzz
Illeterate pinhead
Joined: 26 Jul 2004
Posts: 628
Location: Ministry of Illeteracy, Compruhension Dept
|
Posted:
Mon Jul 30, 2007 10:29 am |
|
"=SUM(BT58)+BT54+BT42+BT24" <> "=SUM(BT58+BT54+BT42+BT24)"
Does this help? |
_________________ "U demon"
"You are one of the antichrist"
"You are not a human being"
x7 |
|
|
|
GordonBennett
Baiting Guru
Joined: 29 Mar 2007
Posts: 2829
Location: Pedicabo ego vos et irrumabo
|
Posted:
Mon Jul 30, 2007 10:48 am |
|
Quote: |
"=SUM(BT58)+BT54+BT42+BT24" <> "=SUM(BT58+BT54+BT42+BT24)" |
Really? Why not, it should be the same.. shouldn't it? |
_________________
DIE MUDER FUCKER
|
|
|
|
shuntbuzz
Illeterate pinhead
Joined: 26 Jul 2004
Posts: 628
Location: Ministry of Illeteracy, Compruhension Dept
|
Posted:
Mon Jul 30, 2007 11:39 am |
|
What I meant was that the OP suggested the bug appeared in the first version - what would the result be using the second? That would narrow the location of the bug down. |
_________________ "U demon"
"You are one of the antichrist"
"You are not a human being"
x7 |
|
|
|
thud419
Baiting Guru
Joined: 04 Jan 2006
Posts: 3193
|
Posted:
Mon Jul 30, 2007 1:13 pm |
|
The correct form is either
Code: |
=sum(BT58,BT54,BT42,BT24) |
or
Code: |
=BT58+BT54+BT42+BT24 |
but any of the other versions work OK in Excel 2003, they're just redundant. |
_________________ Click here to feel warm and cozy.
I did not f**k your wife in any way -- Nike Akanbi
I don't know what else to do or do I continue filling and filling forms. -- Barr. Koloti
you has been dribbling me up and down but I will show some thing you have never seen before, I think you breath air wait and see. -- Barr. Cole
x14
x 0.25 won from Reaper in a sucker's bet
x8 x several |
|
|
|
Lester
Baiting Guru
Joined: 20 Nov 2003
Posts: 2625
Location: Somewhere between here and there
|
Posted:
Mon Jul 30, 2007 2:14 pm |
|
Are you sure its a number in the BT58? and not labeled as text? ive seen excel do weird stuff to numbers that isnt formated as a number |
_________________ x3 - R&H Spam Skit.
x2 x6
x75
$3,838,681.54 of fake checks taken off the street
x13 x4 4y 3m
_____
"Just open up and tell me the truth and stop tricking your dick." - Mr.Kofi Yousaof
"I'm a Muslim, Ok I'm a Christian, Mother F---. Get the F---- off my phone N-----, don't call me anymore." - A lad on the phone with "Homeland Security". |
|
|
|
kleindoofy
*** BANNED ***
Joined: 24 Oct 2004
Posts: 6248
Location: Europe
|
Posted:
Mon Jul 30, 2007 7:33 pm |
|
digital-one wrote: |
... Seems excel 2007 really cant add up correctly. ... |
Please tell me why I'm not surprised.
I'm just glad my business is small enough, resp. structured in such a way that I can do without programs like that. |
|
|
|
|
wokabo
Master of Master Baiters
Joined: 23 Sep 2004
Posts: 825
Location: best beer country in onomatopoeia world
|
Posted:
Tue Jul 31, 2007 11:17 am |
|
I tried my best (with Excel 2007) to add everything up like you said but all I get every time is 67. |
_________________
Fight My Brute |
|
|
|
|