View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
Steven Sinclair Steven Sinclair is offline
external usenet poster
 
Posts: 21
Default 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?