Looks like a stupid human error to me, rather than an Excel bug.
Set up the same column of numbers with 0 for car expenses--it will correctly sum to 9000. Then select the car expenses cell and type in 500--the spreadsheet will appear as shown (with the sum = 9000) until you accept the change.
I'll none-the-less agree that this exemplifies the seeming inability of MS management to do much of anything right these days.
Again, I doubt that is an actual error on the Mac's or iWork's part...
However, after that people were pointing out articles that Numbers actually does botch numbers and nobody disputed those claims, and some Apple fans called the numbers mistakes 'nitpicking' which really it isn't if the mistakes were real.
DED later confirmed that the errors in his charts were indeed some type of 'typo' on his part and he fixed them.
Then again, if Numbers is so difficult to use that even DED has trouble making charts from 7 line items of data.............
To err is human, to really stuff up requires a MS Product, to REALLY stuff up BIG TIME, requires posting it on public arenas
To really, really stuff up big time, requires posting about someone elses mistake on a public arena while making similar mistakes of your own, as DED did.
The $500 is still in an actively editing cell,and therefore is not showing in the total. I learnt that back when I had a IIe. Surprised people making fun of this, just to show their own infamilarity with the program.
Just how desperate is MS, that they've resorted to *advertising* Excel?
Office is entrenched. Has been for years. I can't remember the last time I've seen any of it marketed so openly like this.
We're talking about the so-called lowly iWork, something that MS recently dismissed. And now they're trying to promote their spreadsheet software over Apple's? LMAO
Office software is MS' last bastion. They can't do hardware right (or profitably.) They've already screwed their OEM partners. And now they feel their core biz being threatened by Apple's little Office suite.
Huh? They're showing that the Surface can run Excel, in an attempt to promote the tablet. The ads don't have anything to do with iWork - the author's attempt to draw that conclusion is inaccurate. I'm sure many here like iWork, but it will never gain any traffic with Fortune 500 companies (not that Apple cares, in all likelihood), unless Apple makes a PC-compatible version.
Again, I doubt that is an actual error on the Mac's or iWork's part...
However, after that people were pointing out articles that Numbers actually does botch numbers and nobody disputed those claims, and some Apple fans called the numbers mistakes 'nitpicking' which really it isn't if the mistakes were real.
DED later confirmed that the errors in his charts were indeed some type of 'typo' on his part and he fixed them.
Then again, if Numbers is so difficult to use that even DED has trouble making charts from 7 line items of data.............
Give up. Your post is not just nitpicky, but it's past pointlessness.
.... all of which are fairly benign, of course, compared to getting Ballsilled.... " src="http://forums-files.appleinsider.com/images/smilies//lol.gif" />
To really, really stuff up big time, requires posting about someone elses mistake on a public arena while making similar mistakes of your own, as DED did.
I love this unspoken arbitrary rule that says only perfect people can point out others' imperfections. There's no such rule.
The responsible parties for this ad don't get a free pass just because you've impugned DED's character.
Take DED out of the equation, and you're still left with an error on a screenshot of Microsoft Excel.
I love this unspoken arbitrary rule that says only perfect people can point out others' imperfections. There's no such rule.
The responsible parties for this ad don't get a free pass just because you've impugned DED's character.
Take DED out of the equation, and you're still left with an error on a screenshot of Microsoft Excel.
Add DED back into the equation and you've got some hilarious irony though, lol. That really was the only thing that made this article worthwhile. I don't care how much one hates Microsoft, a minor error like that in an advertising mockup is nothing new or newsworthy.
I love this unspoken arbitrary rule that says only perfect people can point out others' imperfections. There's no such rule.
The responsible parties for this ad don't get a free pass just because you've impugned DED's character.
Take DED out of the equation, and you're still left with an error on a screenshot of Microsoft Excel.
Add DED back into the equation and you've got some hilarious irony though, lol. That really was the only thing that made this article worthwhile. I don't care how much one hates Microsoft, a minor error like that in an advertising mockup is nothing new or newsworthy.
Glad you're enjoying the 'hilarious irony.'
I really don't think it matters a whole heck of a lot to most people here.
I really don't think it matters a whole heck of a lot to most people here.
Of that I have no doubt.
I also enjoy the irony of people who nitpick at someone making a spelling mistake while making speling mistakes of their own. Anyone who would take either spelling mistake as something serious and not just sit back and enjoy the irony could use a heaping helping of lighten the f*&% up.
From my experience you can't do serious work on google spreadsheet nor on numbers. For light users it's probably the same or even better than excel but if you want to do more you have to go with excel.
That's a big part of why MS can sell its suite where the others have to give it out for free.
I wish apple adds functionality and features and I am sure they will. You cannot not have pivot tables for example.
Microsoft is giving away Office for free because this phantom of "serious work" doesn't exist for most people. Sure Microsoft might have enterprise under the thumb, but that weight is shrinking daily as more users realize you don't need expensive and bloated Word, or Excel for the functions most people use.
If Office was such a grand commodity, bet your ass Microsoft would not be giving it away.
Don't be like the obtuse masses that said the iPad would be a flop because you can't do "serious work" on it. Realize computing 2013 has evolved dramatically over computing 2007, and Office just isn't regarded as necessary anymore with the exception being a very small minority.
Microsoft is giving away Office for free because this phantom of "serious work" doesn't exist for most people. Sure Microsoft might have enterprise under the thumb, but that weight is shrinking daily as more users realize you don't need expensive and bloated Word, or Excel for the functions most people use.
If Office was such a grand commodity, bet your ass Microsoft would not be giving it away.
I would like a free copy of Office. Care to point me to where I can legally obtain one?
Since Office 2011 I've noticed that Excel is less smart about updating the ranges of formulas automatically as I add and delete rows. So using the screen shot shown here, I can imagine setting up the total cell with all but the last two budget items, then adding two more budget items and the range for the total doesn't expand automatically to include them. That might explain the $500 error.
Whenever I build an estimate for a client I double-check all the subtotal and total formulas before sending to make sure they still use the correct ranges. If I don't adjust them, my totals are lower than they should be, which would require an embarrassing exchange with a potential client ... "oh, sorry, my price is actually higher than what I sent you." I never had that problem in earlier versions of Excel.
I really don't think it matters a whole heck of a lot to most people here.
Of that I have no doubt.
I also enjoy the irony of people who nitpick at someone making a spelling mistake while making speling mistakes of their own. Anyone who would take either spelling mistake as something serious and not just sit back and enjoy the irony could use a heaping helping of lighten the f*&% up.
Not sure who here gets bent out of shape about spelling mistakes, unless it happens to be in the headline of a story.
That said, even you'd agree that a spelling mistake in an ad is likely to reflect poorly on the company, no?
Comments
Set up the same column of numbers with 0 for car expenses--it will correctly sum to 9000. Then select the car expenses cell and type in 500--the spreadsheet will appear as shown (with the sum = 9000) until you accept the change.
I'll none-the-less agree that this exemplifies the seeming inability of MS management to do much of anything right these days.
Um... what do you think?
From my original response:
Again, I doubt that is an actual error on the Mac's or iWork's part...
However, after that people were pointing out articles that Numbers actually does botch numbers and nobody disputed those claims, and some Apple fans called the numbers mistakes 'nitpicking' which really it isn't if the mistakes were real.
DED later confirmed that the errors in his charts were indeed some type of 'typo' on his part and he fixed them.
Then again, if Numbers is so difficult to use that even DED has trouble making charts from 7 line items of data.............
To err is human, to really stuff up requires a MS Product, to REALLY stuff up BIG TIME, requires posting it on public arenas
To really, really stuff up big time, requires posting about someone elses mistake on a public arena while making similar mistakes of your own, as DED did.
Think about it for a moment.
Just how desperate is MS, that they've resorted to *advertising* Excel?
Office is entrenched. Has been for years. I can't remember the last time I've seen any of it marketed so openly like this.
We're talking about the so-called lowly iWork, something that MS recently dismissed. And now they're trying to promote their spreadsheet software over Apple's? LMAO
Office software is MS' last bastion. They can't do hardware right (or profitably.) They've already screwed their OEM partners. And now they feel their core biz being threatened by Apple's little Office suite.
Huh? They're showing that the Surface can run Excel, in an attempt to promote the tablet. The ads don't have anything to do with iWork - the author's attempt to draw that conclusion is inaccurate. I'm sure many here like iWork, but it will never gain any traffic with Fortune 500 companies (not that Apple cares, in all likelihood), unless Apple makes a PC-compatible version.From my original response:
Again, I doubt that is an actual error on the Mac's or iWork's part...
However, after that people were pointing out articles that Numbers actually does botch numbers and nobody disputed those claims, and some Apple fans called the numbers mistakes 'nitpicking' which really it isn't if the mistakes were real.
DED later confirmed that the errors in his charts were indeed some type of 'typo' on his part and he fixed them.
Then again, if Numbers is so difficult to use that even DED has trouble making charts from 7 line items of data.............
Give up. Your post is not just nitpicky, but it's past pointlessness.
Get a sense of humor.
Microsoft Word and Excel. Hmmmm. I remember those. Aren't they from the 1960's?
No, I think you are thinking of WordStar and Visicalc.
You may have missed davesmall's point
Too funny
Before long...
Shawed == Ballmered == Sinofskyed == Borked
.... all of which are fairly benign, of course, compared to getting Ballsilled....
" src="http://forums-files.appleinsider.com/images/smilies//lol.gif" />
To really, really stuff up big time, requires posting about someone elses mistake on a public arena while making similar mistakes of your own, as DED did.
I love this unspoken arbitrary rule that says only perfect people can point out others' imperfections. There's no such rule.
The responsible parties for this ad don't get a free pass just because you've impugned DED's character.
Take DED out of the equation, and you're still left with an error on a screenshot of Microsoft Excel.
I love this unspoken arbitrary rule that says only perfect people can point out others' imperfections. There's no such rule.
The responsible parties for this ad don't get a free pass just because you've impugned DED's character.
Take DED out of the equation, and you're still left with an error on a screenshot of Microsoft Excel.
Add DED back into the equation and you've got some hilarious irony though, lol. That really was the only thing that made this article worthwhile. I don't care how much one hates Microsoft, a minor error like that in an advertising mockup is nothing new or newsworthy.
I love this unspoken arbitrary rule that says only perfect people can point out others' imperfections. There's no such rule.
The responsible parties for this ad don't get a free pass just because you've impugned DED's character.
Take DED out of the equation, and you're still left with an error on a screenshot of Microsoft Excel.
Add DED back into the equation and you've got some hilarious irony though, lol. That really was the only thing that made this article worthwhile. I don't care how much one hates Microsoft, a minor error like that in an advertising mockup is nothing new or newsworthy.
Glad you're enjoying the 'hilarious irony.'
I really don't think it matters a whole heck of a lot to most people here.
Glad you're enjoying the 'hilarious irony.'
I really don't think it matters a whole heck of a lot to most people here.
Of that I have no doubt.
I also enjoy the irony of people who nitpick at someone making a spelling mistake while making speling mistakes of their own. Anyone who would take either spelling mistake as something serious and not just sit back and enjoy the irony could use a heaping helping of lighten the f*&% up.
From my experience you can't do serious work on google spreadsheet nor on numbers. For light users it's probably the same or even better than excel but if you want to do more you have to go with excel.
That's a big part of why MS can sell its suite where the others have to give it out for free.
I wish apple adds functionality and features and I am sure they will. You cannot not have pivot tables for example.
Microsoft is giving away Office for free because this phantom of "serious work" doesn't exist for most people. Sure Microsoft might have enterprise under the thumb, but that weight is shrinking daily as more users realize you don't need expensive and bloated Word, or Excel for the functions most people use.
If Office was such a grand commodity, bet your ass Microsoft would not be giving it away.
Don't be like the obtuse masses that said the iPad would be a flop because you can't do "serious work" on it. Realize computing 2013 has evolved dramatically over computing 2007, and Office just isn't regarded as necessary anymore with the exception being a very small minority.
Quote:
Microsoft is giving away Office for free because this phantom of "serious work" doesn't exist for most people. Sure Microsoft might have enterprise under the thumb, but that weight is shrinking daily as more users realize you don't need expensive and bloated Word, or Excel for the functions most people use.
If Office was such a grand commodity, bet your ass Microsoft would not be giving it away.
I would like a free copy of Office. Care to point me to where I can legally obtain one?
Since Office 2011 I've noticed that Excel is less smart about updating the ranges of formulas automatically as I add and delete rows. So using the screen shot shown here, I can imagine setting up the total cell with all but the last two budget items, then adding two more budget items and the range for the total doesn't expand automatically to include them. That might explain the $500 error.
Whenever I build an estimate for a client I double-check all the subtotal and total formulas before sending to make sure they still use the correct ranges. If I don't adjust them, my totals are lower than they should be, which would require an embarrassing exchange with a potential client ... "oh, sorry, my price is actually higher than what I sent you." I never had that problem in earlier versions of Excel.
Not sure who here gets bent out of shape about spelling mistakes, unless it happens to be in the headline of a story.
That said, even you'd agree that a spelling mistake in an ad is likely to reflect poorly on the company, no?