| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel can't do basic math?!
Here's the deal...
Open Excel New worksheet Enter data Sum data No matter whether I add numbers from column to column or row to row, my totals are always off by exactly 672. What the heck is that?! Example... A B C 140785 276714 418171 Formula in C is "=sum(A1+B1) How much simpler can it get? Any ideas? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Excel can't do basic math?!
hi,
your calculation should set as manual, to calculate press F9, go to Tolls | Options and set calc as automatic hth -- regards from Brazil Thanks in advance for your feedback. Marcelo "Steven Sinclair" escreveu: Here's the deal... Open Excel New worksheet Enter data Sum data No matter whether I add numbers from column to column or row to row, my totals are always off by exactly 672. What the heck is that?! Example... A B C 140785 276714 418171 Formula in C is "=sum(A1+B1) How much simpler can it get? Any ideas? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Excel can't do basic math?!
Or worse, you may have circular references in your workbook. Any warnings
when you open it ? Better read it if so, this is a very dangerous error. HTH. Best wishes Harald "Marcelo" skrev i melding ... hi, your calculation should set as manual, to calculate press F9, go to Tolls | Options and set calc as automatic hth -- regards from Brazil Thanks in advance for your feedback. Marcelo "Steven Sinclair" escreveu: Here's the deal... Open Excel New worksheet Enter data Sum data No matter whether I add numbers from column to column or row to row, my totals are always off by exactly 672. What the heck is that?! Example... A B C 140785 276714 418171 Formula in C is "=sum(A1+B1) How much simpler can it get? Any ideas? |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Excel can't do basic math?!
No warnings...no errors.
Just Excel's apparent inability to do basic math. I can open up a fresh worksheet and put one figure in A1, another in B1, add them together in C1, and the total is always 672 more than it should be. Thanx. "Harald Staff" wrote: Or worse, you may have circular references in your workbook. Any warnings when you open it ? Better read it if so, this is a very dangerous error. HTH. Best wishes Harald "Marcelo" skrev i melding ... hi, your calculation should set as manual, to calculate press F9, go to Tolls | Options and set calc as automatic hth -- regards from Brazil Thanks in advance for your feedback. Marcelo "Steven Sinclair" escreveu: Here's the deal... Open Excel New worksheet Enter data Sum data No matter whether I add numbers from column to column or row to row, my totals are always off by exactly 672. What the heck is that?! Example... A B C 140785 276714 418171 Formula in C is "=sum(A1+B1) How much simpler can it get? Any ideas? |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Excel can't do basic math?!
Really? You enter 1 in A1 and 1 in B1 and formula =A1+B1 in cell C1 returns
674 ? And when you select C1 again the formula is still there unchanged ? Best wishes Harald "Steven Sinclair" skrev i melding ... No warnings...no errors. Just Excel's apparent inability to do basic math. I can open up a fresh worksheet and put one figure in A1, another in B1, add them together in C1, and the total is always 672 more than it should be. Thanx. "Harald Staff" wrote: Or worse, you may have circular references in your workbook. Any warnings when you open it ? Better read it if so, this is a very dangerous error. HTH. Best wishes Harald "Marcelo" skrev i melding ... hi, your calculation should set as manual, to calculate press F9, go to Tolls | Options and set calc as automatic hth -- regards from Brazil Thanks in advance for your feedback. Marcelo "Steven Sinclair" escreveu: Here's the deal... Open Excel New worksheet Enter data Sum data No matter whether I add numbers from column to column or row to row, my totals are always off by exactly 672. What the heck is that?! Example... A B C 140785 276714 418171 Formula in C is "=sum(A1+B1) How much simpler can it get? Any ideas? |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Excel can't do basic math?!
Yep.
"Harald Staff" wrote: Really? You enter 1 in A1 and 1 in B1 and formula =A1+B1 in cell C1 returns 674 ? And when you select C1 again the formula is still there unchanged ? Best wishes Harald "Steven Sinclair" skrev i melding ... No warnings...no errors. Just Excel's apparent inability to do basic math. I can open up a fresh worksheet and put one figure in A1, another in B1, add them together in C1, and the total is always 672 more than it should be. Thanx. "Harald Staff" wrote: Or worse, you may have circular references in your workbook. Any warnings when you open it ? Better read it if so, this is a very dangerous error. HTH. Best wishes Harald "Marcelo" skrev i melding ... hi, your calculation should set as manual, to calculate press F9, go to Tolls | Options and set calc as automatic hth -- regards from Brazil Thanks in advance for your feedback. Marcelo "Steven Sinclair" escreveu: Here's the deal... Open Excel New worksheet Enter data Sum data No matter whether I add numbers from column to column or row to row, my totals are always off by exactly 672. What the heck is that?! Example... A B C 140785 276714 418171 Formula in C is "=sum(A1+B1) How much simpler can it get? Any ideas? |
|
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Excel can't do basic math?!
Have you tried this in other cells in the worksheet?
-- Brevity is the soul of wit. "Steven Sinclair" wrote: No warnings...no errors. Just Excel's apparent inability to do basic math. I can open up a fresh worksheet and put one figure in A1, another in B1, add them together in C1, and the total is always 672 more than it should be. Thanx. "Harald Staff" wrote: Or worse, you may have circular references in your workbook. Any warnings when you open it ? Better read it if so, this is a very dangerous error. HTH. Best wishes Harald "Marcelo" skrev i melding ... hi, your calculation should set as manual, to calculate press F9, go to Tolls | Options and set calc as automatic hth -- regards from Brazil Thanks in advance for your feedback. Marcelo "Steven Sinclair" escreveu: Here's the deal... Open Excel New worksheet Enter data Sum data No matter whether I add numbers from column to column or row to row, my totals are always off by exactly 672. What the heck is that?! Example... A B C 140785 276714 418171 Formula in C is "=sum(A1+B1) How much simpler can it get? Any ideas? |
|
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Excel can't do basic math?!
Yep.
Doesn't matter what cells I use. Also doesn't matter if it is done horizontally or vertically, or even all over the worksheet for that matter...one value in C5, another in HA492, and the total formula in Z1. The total is always 672 more than it should be. I've never seen anything like this before. Other ideas? Thanx. "Dave F" wrote: Have you tried this in other cells in the worksheet? -- Brevity is the soul of wit. "Steven Sinclair" wrote: No warnings...no errors. Just Excel's apparent inability to do basic math. I can open up a fresh worksheet and put one figure in A1, another in B1, add them together in C1, and the total is always 672 more than it should be. Thanx. "Harald Staff" wrote: Or worse, you may have circular references in your workbook. Any warnings when you open it ? Better read it if so, this is a very dangerous error. HTH. Best wishes Harald "Marcelo" skrev i melding ... hi, your calculation should set as manual, to calculate press F9, go to Tolls | Options and set calc as automatic hth -- regards from Brazil Thanks in advance for your feedback. Marcelo "Steven Sinclair" escreveu: Here's the deal... Open Excel New worksheet Enter data Sum data No matter whether I add numbers from column to column or row to row, my totals are always off by exactly 672. What the heck is that?! Example... A B C 140785 276714 418171 Formula in C is "=sum(A1+B1) How much simpler can it get? Any ideas? |
|
#9
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Excel can't do basic math?!
For debugging, I notice that "sum" is not Capitalized.
"=sum(A1+B1)" A proper working formula would most likely be in all Capitals: =SUM(A1,B1) (note that A1+B1 "is" the sum) Also, try the "Evaluate Formula" toolbar button located on the Formula Auditing toolbar. -- HTH. :) Dana DeLouis Windows XP, Office 2003 "Steven Sinclair" wrote in message ... No warnings...no errors. Just Excel's apparent inability to do basic math. I can open up a fresh worksheet and put one figure in A1, another in B1, add them together in C1, and the total is always 672 more than it should be. Thanx. "Harald Staff" wrote: Or worse, you may have circular references in your workbook. Any warnings when you open it ? Better read it if so, this is a very dangerous error. HTH. Best wishes Harald "Marcelo" skrev i melding ... hi, your calculation should set as manual, to calculate press F9, go to Tolls | Options and set calc as automatic hth -- regards from Brazil Thanks in advance for your feedback. Marcelo "Steven Sinclair" escreveu: Here's the deal... Open Excel New worksheet Enter data Sum data No matter whether I add numbers from column to column or row to row, my totals are always off by exactly 672. What the heck is that?! Example... A B C 140785 276714 418171 Formula in C is "=sum(A1+B1) How much simpler can it get? Any ideas? |
|
#10
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Excel can't do basic math?!
Excel automatically capitalizes formulas which are not entered as
capitalized. That wouldn't explain the issue. -- Brevity is the soul of wit. "Dana DeLouis" wrote: For debugging, I notice that "sum" is not Capitalized. "=sum(A1+B1)" A proper working formula would most likely be in all Capitals: =SUM(A1,B1) (note that A1+B1 "is" the sum) Also, try the "Evaluate Formula" toolbar button located on the Formula Auditing toolbar. -- HTH. :) Dana DeLouis Windows XP, Office 2003 "Steven Sinclair" wrote in message ... No warnings...no errors. Just Excel's apparent inability to do basic math. I can open up a fresh worksheet and put one figure in A1, another in B1, add them together in C1, and the total is always 672 more than it should be. Thanx. "Harald Staff" wrote: Or worse, you may have circular references in your workbook. Any warnings when you open it ? Better read it if so, this is a very dangerous error. HTH. Best wishes Harald "Marcelo" skrev i melding ... hi, your calculation should set as manual, to calculate press F9, go to Tolls | Options and set calc as automatic hth -- regards from Brazil Thanks in advance for your feedback. Marcelo "Steven Sinclair" escreveu: Here's the deal... Open Excel New worksheet Enter data Sum data No matter whether I add numbers from column to column or row to row, my totals are always off by exactly 672. What the heck is that?! Example... A B C 140785 276714 418171 Formula in C is "=sum(A1+B1) How much simpler can it get? Any ideas? |
|
#11
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Excel can't do basic math?!
Nope...calculation is already set to automatic.
Any other ideas? Thanx. "Marcelo" wrote: hi, your calculation should set as manual, to calculate press F9, go to Tolls | Options and set calc as automatic hth -- regards from Brazil Thanks in advance for your feedback. Marcelo "Steven Sinclair" escreveu: Here's the deal... Open Excel New worksheet Enter data Sum data No matter whether I add numbers from column to column or row to row, my totals are always off by exactly 672. What the heck is that?! Example... A B C 140785 276714 418171 Formula in C is "=sum(A1+B1) How much simpler can it get? Any ideas? |
|
#12
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Excel can't do basic math?!
Forgot to mention that my Excel has been working fine for over three years
until this morning. Thanx. "Steven Sinclair" wrote: Here's the deal... Open Excel New worksheet Enter data Sum data No matter whether I add numbers from column to column or row to row, my totals are always off by exactly 672. What the heck is that?! Example... A B C 140785 276714 418171 Formula in C is "=sum(A1+B1) How much simpler can it get? Any ideas? |
|
#13
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Excel can't do basic math?!
Does the pc's calculator perform addition correctly?
-- Brevity is the soul of wit. "Steven Sinclair" wrote: Forgot to mention that my Excel has been working fine for over three years until this morning. Thanx. "Steven Sinclair" wrote: Here's the deal... Open Excel New worksheet Enter data Sum data No matter whether I add numbers from column to column or row to row, my totals are always off by exactly 672. What the heck is that?! Example... A B C 140785 276714 418171 Formula in C is "=sum(A1+B1) How much simpler can it get? Any ideas? |
|
#14
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Excel can't do basic math?!
I tried something simple like 1+1=2. I added a number in A1 and a number in
B1 and put the sum in C1. I tried it your way, =sum(a1,b1) and my way, =SUM(A1:B1). Both ways added up to 2. The only time my Excel ever went haywire was when I got a virus. -- Claudia "Steven Sinclair" wrote: Here's the deal... Open Excel New worksheet Enter data Sum data No matter whether I add numbers from column to column or row to row, my totals are always off by exactly 672. What the heck is that?! Example... A B C 140785 276714 418171 Formula in C is "=sum(A1+B1) How much simpler can it get? Any ideas? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? | Excel Discussion (Misc queries) | |||
| Running Excel 2000 VBA Application on Excel 2003 | Excel Worksheet Functions | |||
| Using Excel 2000 VBA Application on Excel 2003 | Excel Worksheet Functions | |||
| I Visual Basic Error "File Not Found" when Excel opens | Excel Discussion (Misc queries) | |||
| Throubles with Visual Basic and Excel | Excel Worksheet Functions | |||
Hybrid Mode
