Numbers to add properly

[Wayne G. Dengel]

Is it common for Excel 2002 to not add correctly, i.e be off by a factor of
1?

I have a file - 30-40 numbers, $s w/o and cents - plain dollars. I found
that I was off by $1.oo this afternoon - mine compared to our accountant
where her tape showed $1 greater (hers was higher by $1.).

I then added a column with the units nbrs from the original big dollars
column only, $2003 was 3, $89 was 9 and so forth. There it was. Adding
single digits showed/added correctly.

Format is $s with no digits to the right of the decimal point. What is
happening here?

Wayne

 

[Gary Miller]

Not sure from the info you supplied. What is your data type
in the underlying table? It should be set to Currency if you
are dealing with dollars. Sounds like it may be the default
of Integer which allows no decimals.

Gary Miller

 

[Wayne G. Dengel]

Pls excuse the lack of clarity.

I have a column in which I have dollars, no cents, i.e $8., $25., $25,643.,
468. etc. In all there are about 250 items, entries.
..
The net total is exactly $1 short of the real/correct amount. (Please know,
again there are no cents figures to cause a rounding when displays whole
dollars.)
This was
determined by generating another column, side-by-side with the first where I
manually entered the units digit for each item. Using the four sasmple
numbers above, there would be an 8, the second would be a 5, 3, 8 and so
forth. For this single digit column, it added correctly, i.e. the units
digit would be a 4.

In the columns where complete numbers are added, the units column has a 3 in
it!

Again, the format is $s with no cents. (Makes no sense does it?)

Wayne

 

[John Nurick]

Hi Wayne,

I'm not aware of any basic arithmetic problems in Excel 2002.

Are the numbers in your column
1 whole numbers that you typed in
2 the results of formulas
3 numbers including cents, but formatted to display only whole dollars?

If 2 or 3, rounding errors could produce the effect you are observing.
Also, are there any hidden rows?

But this newsgroup is for people getting started with the Microsoft
Access database software, so it's not a good place for questions about
Excel. You'll be more likely to get an answer in an Excel newsgroup such
as microsoft.public.excel.newusers.

Pls excuse the lack of clarity.

I have a column in which I have dollars, no cents, i.e $8., $25., $25,643.,
468. etc. In all there are about 250 items, entries.
.
The net total is exactly $1 short of the real/correct amount. (Please know,
again there are no cents figures to cause a rounding when displays whole
dollars.)
This was
determined by generating another column, side-by-side with the first where I
manually entered the units digit for each item. Using the four sasmple
numbers above, there would be an 8, the second would be a 5, 3, 8 and so
forth. For this single digit column, it added correctly, i.e. the units
digit would be a 4.

In the columns where complete numbers are added, the units column has a 3 in
it!

Again, the format is $s with no cents. (Makes no sense does it?)

Wayne

John Nurick [Microsoft Access MVP]

Please respond in the newgroup and not by email.

 

[Wayne G. Dengel]

Hi! I messed up. Nbrs in column that was summed came from an adjacent
column were cents were involved. Though format in summed col was set for
whole dollars, the cents carries through and effects the bottom line.

My mess up!

Thank you for your comment/feedback.

Wayne

PS As for the Excel problem being on the Access site, I must have been
dreaming that night: problem was really not a problem just my dumbness and
add to this I was on the wrong site!!

Hi Wayne,

I'm not aware of any basic arithmetic problems in Excel 2002.

Are the numbers in your column
1 whole numbers that you typed in
2 the results of formulas
3 numbers including cents, but formatted to display only whole dollars?

If 2 or 3, rounding errors could produce the effect you are observing.
Also, are there any hidden rows?

But this newsgroup is for people getting started with the Microsoft
Access database software, so it's not a good place for questions about
Excel. You'll be more likely to get an answer in an Excel newsgroup such
as microsoft.public.excel.newusers.

Pls excuse the lack of clarity.

I have a column in which I have dollars, no cents, i.e $8., $25., $25,643.,
468. etc. In all there are about 250 items, entries.
.
The net total is exactly $1 short of the real/correct amount. (Please know,
again there are no cents figures to cause a rounding when displays whole
dollars.)
This was
determined by generating another column, side-by-side with the first where I
manually entered the units digit for each item. Using the four sasmple
numbers above, there would be an 8, the second would be a 5, 3, 8 and so
forth. For this single digit column, it added correctly, i.e. the units
digit would be a 4.

In the columns where complete numbers are added, the units column has a 3 in
it!

Again, the format is $s with no cents. (Makes no sense does it?)

Wayne

John Nurick [Microsoft Access MVP]

Please respond in the newgroup and not by email.