software

I am a pretty competent user of Excel, but on some occassions, a simple
formula like SUM will not work. Whether doing it using the Sum (Sigma) icon
or creating the formula in the formula bar (ex. =A12 A13) it is not working.
I have tried clearing and deleting the cells and recreating them, it doesn't
matter. If I redo the formula with the actual number values in each cell it
will work but it is as if it isn't reading the values in the cells properly.
I have tried looking at the cell properties and can not find anything
obvious. Please help. Thank you. - CG

It might be a rounding error problem. If you have 1.4 in both A12 and
A13 but these are formatted as number with 0 decimal places, they will
both show as 1, but the answer to the formula will show as 3.

PetePete,

By the way one other thing I should have mentioned is that I did check and
verify the the Tools-Options-Calculations is set to automatic as I noticed
that advice on several other related posts.

CG

quot;Petequot; wrote:

gt; It might be a rounding error problem. If you have 1.4 in both A12 and
gt; A13 but these are formatted as number with 0 decimal places, they will
gt; both show as 1, but the answer to the formula will show as 3.
gt;
gt; Pete
gt;
gt;

Pete,

That is not the case, I have 6535 in one cell, trying to add it to (3700)
and it is coming up with zero...I have also tried moving other cells and
doing the same thing and have come up with other incorrect answers. I have
also tried putting the following:
A12 A13
A12-A13
A12 (A13)
and A12-(-A13)
None of these have produced the correct answer of 2835 which I could easily
do by hand, but I am trying to do a 5 year business pamp;l build out and that
will take forever and lead to issues if I can not get a simple formula like
SUM to work in this worksheet.

Also in the short time it took you to respond (which thank you so much for
the incredibly quick response) I tried duing the Error Check tool and now
every formula in the spread sheet is showing the formula and not the value
and I have looked around and can not figure out how to change it back to
normal. If you could advise on that as well it would be appreciated.

CG

quot;Petequot; wrote:

gt; It might be a rounding error problem. If you have 1.4 in both A12 and
gt; A13 but these are formatted as number with 0 decimal places, they will
gt; both show as 1, but the answer to the formula will show as 3.
gt;
gt; Pete
gt;
gt;

Hi,
I was able to recreate your problem by going to Tools/Options/Transition and
putting a check mark in quot;Transition Formula Evaluationquot;.

Not sure what it does tho.

HTH
JG

quot;crzyg8rquot; wrote:

gt; Pete,
gt;
gt; By the way one other thing I should have mentioned is that I did check and
gt; verify the the Tools-Options-Calculations is set to automatic as I noticed
gt; that advice on several other related posts.
gt;
gt; CG
gt;
gt; quot;Petequot; wrote:
gt;
gt; gt; It might be a rounding error problem. If you have 1.4 in both A12 and
gt; gt; A13 but these are formatted as number with 0 decimal places, they will
gt; gt; both show as 1, but the answer to the formula will show as 3.
gt; gt;
gt; gt; Pete
gt; gt;
gt; gt;

Hi!

Use the key combo of CTRL ` to toggle between formula view and normal view
or goto Toolsgt;Optionsgt;Viewgt;Formulas.

Your problem might be that some of your values have been formatted as TEXT.

A1 = 6535
A2 = 3700

=SUM(A1:A2)

If that formula returns 0 then the values are TEXT

Try this:

Select an empty cell and make sure that it's formatted as GENERAL

Copy that empty cell
Select the cells that contain your number values
Goto Editgt;Paste Specialgt;Addgt;OK

That will quot;forcequot; the values to convert to a GENERAL format.

Biff

quot;crzyg8rquot; gt; wrote in message
...
gt; Pete,
gt;
gt; That is not the case, I have 6535 in one cell, trying to add it to (3700)
gt; and it is coming up with zero...I have also tried moving other cells and
gt; doing the same thing and have come up with other incorrect answers. I
gt; have
gt; also tried putting the following:
gt; A12 A13
gt; A12-A13
gt; A12 (A13)
gt; and A12-(-A13)
gt; None of these have produced the correct answer of 2835 which I could
gt; easily
gt; do by hand, but I am trying to do a 5 year business pamp;l build out and that
gt; will take forever and lead to issues if I can not get a simple formula
gt; like
gt; SUM to work in this worksheet.
gt;
gt; Also in the short time it took you to respond (which thank you so much for
gt; the incredibly quick response) I tried duing the Error Check tool and now
gt; every formula in the spread sheet is showing the formula and not the value
gt; and I have looked around and can not figure out how to change it back to
gt; normal. If you could advise on that as well it would be appreciated.
gt;
gt; CG
gt;
gt; quot;Petequot; wrote:
gt;
gt;gt; It might be a rounding error problem. If you have 1.4 in both A12 and
gt;gt; A13 but these are formatted as number with 0 decimal places, they will
gt;gt; both show as 1, but the answer to the formula will show as 3.
gt;gt;
gt;gt; Pete
gt;gt;
gt;gt;