Sum Error!!

S

skc

Excel 2000 on a Windows 2000 Pro machine

When I highlight a few cells in a column full of numbers,
it shows me the sum in the grey area towards the bottom
right.

When I highlight some numbers, I get 1.000e234 or
something similar! This seems to happen when the sum is
0, so summing -100 + 100.

Why is this? How do I solve the problem?

skc
 
P

Paul

skc said:
Excel 2000 on a Windows 2000 Pro machine

When I highlight a few cells in a column full of numbers,
it shows me the sum in the grey area towards the bottom
right.

When I highlight some numbers, I get 1.000e234 or
something similar! This seems to happen when the sum is
0, so summing -100 + 100.

Why is this? How do I solve the problem?

skc
Click to expand...

It's only a 'rounding error' - a very tiny little bit different from zero
because of the way computers do arithmetic. There's no problem to fix!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Word docs emailed to me are opening blank (greyed screen) in Print Mode 0
IF Function error #VALUE 2
Auto Sum not working correctly 1
Trying to make averages AND sums of one spreadsheet of information 0
An Odd problem with SUM using : 0
autosum refusal to sum highlighted range 4
SUM TOTALS AT BOTTOM OF WORKSHEET 2
SUMIF based on several criteria. 6

Top