SmartFeedSmartFeed          

Porsche Hangout


WELCOME - YOU ARE CURRENTLY VIEWING 419EATER AS A GUEST

By joining our community you will have the ability to post topics and access other forums reserved for members. Registration is quick, simple and absolutely free. Join our community today by clicking here.

ScamWarners.com - Internet Anti-Fraud Center - now open!


 Excel 2007 dont add up

View next topic
View previous topic
 
Post new topicReply to topic
Author Message
D11
Elite Baiter


Joined: 02 Jul 2006
Posts: 1702


PostPosted: Mon Jul 30, 2007 7:34 am Reply with quoteBack to top

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?

_________________
star
1x United Kingdom 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
View user's profileSend private message
Zorro
419Eater is my life


Joined: 01 Feb 2007
Posts: 377
Location: In levitation


PostPosted: Mon Jul 30, 2007 7:39 am Reply with quoteBack to top

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.
View user's profileSend private message
D11
Elite Baiter


Joined: 02 Jul 2006
Posts: 1702


PostPosted: Mon Jul 30, 2007 7:43 am Reply with quoteBack to top

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.

_________________
star
1x United Kingdom 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
View user's profileSend private message
Zorro
419Eater is my life


Joined: 01 Feb 2007
Posts: 377
Location: In levitation


PostPosted: Mon Jul 30, 2007 7:46 am Reply with quoteBack to top

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.
View user's profileSend private message
thud419
Baiting Guru


Joined: 04 Jan 2006
Posts: 3193


PostPosted: Mon Jul 30, 2007 8:28 am Reply with quoteBack to top

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. -- Sand Timer Barr. Cole
Cellphone x14
United States x 0.25 won from Reaper in a sucker's bet

Hello Kitty! pony Mortar x8 Closed lad accounts x several
View user's profileSend private messageSend e-mailVisit poster's website
shuntbuzz
Illeterate pinhead


Joined: 26 Jul 2004
Posts: 628
Location: Ministry of Illeteracy, Compruhension Dept


PostPosted: Mon Jul 30, 2007 10:29 am Reply with quoteBack to top

"=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"

Mortar x7
View user's profileSend private message
GordonBennett
Baiting Guru


Joined: 29 Mar 2007
Posts: 2829
Location: Pedicabo ego vos et irrumabo


PostPosted: Mon Jul 30, 2007 10:48 am Reply with quoteBack to top

Quote:
"=SUM(BT58)+BT54+BT42+BT24" <> "=SUM(BT58+BT54+BT42+BT24)"

Really? Why not, it should be the same.. shouldn't it?

_________________
Ninja
DIE MUDER FUCKER

Purple Flower
View user's profileSend private message
shuntbuzz
Illeterate pinhead


Joined: 26 Jul 2004
Posts: 628
Location: Ministry of Illeteracy, Compruhension Dept


PostPosted: Mon Jul 30, 2007 11:39 am Reply with quoteBack to top

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"

Mortar x7
View user's profileSend private message
thud419
Baiting Guru


Joined: 04 Jan 2006
Posts: 3193


PostPosted: Mon Jul 30, 2007 1:13 pm Reply with quoteBack to top

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. -- Sand Timer Barr. Cole
Cellphone x14
United States x 0.25 won from Reaper in a sucker's bet

Hello Kitty! pony Mortar x8 Closed lad accounts x several
View user's profileSend private messageSend e-mailVisit poster's website
Lester
Carrot Dangler


Joined: 20 Nov 2003
Posts: 2534
Location: Somewhere between here and there


PostPosted: Mon Jul 30, 2007 2:14 pm Reply with quoteBack to top

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

_________________
Vcamera x3 - R&H Spam Skit.
pyramid x2 United Kingdom x6 Netherlands Hong Kong Nigeria
Closed lad accounts x75
$3,838,681.54 of fake checks taken off the street
Mortar x13 Tattoo x4 Sand Timer 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".
View user's profileSend private messageSkype Name
kleindoofy
*** BANNED ***


Joined: 24 Oct 2004
Posts: 6248
Location: Europe


PostPosted: Mon Jul 30, 2007 7:33 pm Reply with quoteBack to top

digital-one wrote:
... Seems excel 2007 really cant add up correctly. ...


Please tell me why I'm not surprised. Confused

I'm just glad my business is small enough, resp. structured in such a way that I can do without programs like that. Very Happy
View user's profileSend private message
wokabo
Master of Master Baiters


Joined: 23 Sep 2004
Posts: 825
Location: best beer country in onomatopoeia world


PostPosted: Tue Jul 31, 2007 11:17 am Reply with quoteBack to top

I tried my best (with Excel 2007) to add everything up like you said but all I get every time is 67.

_________________
pony pony pony

Fight My Brute
View user's profileSend private message
Display posts from previous:      
Post new topicReply to topic


 Jump to:   



View next topic
View previous topic
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum



** Find out information about your IP address **


All Content © 2003 - 419Eater.com
Powered by phpBB © 2001, 2002 phpBB Group :S5: FI Theme :: All times are GMT