I have a simple sum problem. I have the following data entered. The sum total
in excel =49.604
When you add these up it should read 49.607
What the heck is going on?
Scott
1.802
2.337
1.942
1.330
0.885
1.910
1.780
2.927
2.413
2.617
1.297
0.522
2.453
2.582
2.388
1.453
1.751
0.794
0.769
2.170
1.689
2.391
2.007
1.265
1.081
0.821
1.761
2.470
0.000
0.000
0.000
http://www.mcgimpsey.com/excel/pennyoff.html
--
Kind regards,
Niek Otten
"scott" <[email protected]> wrote in message
news:[email protected]...
>I have a simple sum problem. I have the following data entered. The sum
>total
> in excel =49.604
> When you add these up it should read 49.607
> What the heck is going on?
> Scott
> 1.802
> 2.337
> 1.942
> 1.330
> 0.885
> 1.910
> 1.780
> 2.927
> 2.413
> 2.617
> 1.297
> 0.522
> 2.453
> 2.582
> 2.388
> 1.453
> 1.751
> 0.794
> 0.769
> 2.170
> 1.689
> 2.391
> 2.007
> 1.265
> 1.081
> 0.821
> 1.761
> 2.470
> 0.000
> 0.000
> 0.000
>
Niek
Thanks but I do not understand how to enter the formula, to make it work
correctly
scott
"Niek Otten" wrote:
> http://www.mcgimpsey.com/excel/pennyoff.html
>
>
> --
> Kind regards,
>
> Niek Otten
>
> "scott" <[email protected]> wrote in message
> news:[email protected]...
> >I have a simple sum problem. I have the following data entered. The sum
> >total
> > in excel =49.604
> > When you add these up it should read 49.607
> > What the heck is going on?
> > Scott
> > 1.802
> > 2.337
> > 1.942
> > 1.330
> > 0.885
> > 1.910
> > 1.780
> > 2.927
> > 2.413
> > 2.617
> > 1.297
> > 0.522
> > 2.453
> > 2.582
> > 2.388
> > 1.453
> > 1.751
> > 0.794
> > 0.769
> > 2.170
> > 1.689
> > 2.391
> > 2.007
> > 1.265
> > 1.081
> > 0.821
> > 1.761
> > 2.470
> > 0.000
> > 0.000
> > 0.000
> >
>
>
>
Niek
I checked the persision and it said it may effect accuracey is this going to
be a big problem i have allot of calulations going on envoling decimal points
scott
"Niek Otten" wrote:
> http://www.mcgimpsey.com/excel/pennyoff.html
>
>
> --
> Kind regards,
>
> Niek Otten
>
> "scott" <[email protected]> wrote in message
> news:[email protected]...
> >I have a simple sum problem. I have the following data entered. The sum
> >total
> > in excel =49.604
> > When you add these up it should read 49.607
> > What the heck is going on?
> > Scott
> > 1.802
> > 2.337
> > 1.942
> > 1.330
> > 0.885
> > 1.910
> > 1.780
> > 2.927
> > 2.413
> > 2.617
> > 1.297
> > 0.522
> > 2.453
> > 2.582
> > 2.388
> > 1.453
> > 1.751
> > 0.794
> > 0.769
> > 2.170
> > 1.689
> > 2.391
> > 2.007
> > 1.265
> > 1.081
> > 0.821
> > 1.761
> > 2.470
> > 0.000
> > 0.000
> > 0.000
> >
>
>
>
It depends on what you require.
If you don't want to lose any accuracy, format all your numbers as General
and widen the column so you see all decimals. You may find that the numbers
now look different from before.
If you insist on calculating with 3 decimals, either use the ROUND()
function for all of the numbers or apply Precision as displayed.
--
Kind regards,
Niek Otten
"scott" <[email protected]> wrote in message
news:[email protected]...
> Niek
> I checked the persision and it said it may effect accuracey is this going
> to
> be a big problem i have allot of calulations going on envoling decimal
> points
> scott
>
> "Niek Otten" wrote:
>
>> http://www.mcgimpsey.com/excel/pennyoff.html
>>
>>
>> --
>> Kind regards,
>>
>> Niek Otten
>>
>> "scott" <[email protected]> wrote in message
>> news:[email protected]...
>> >I have a simple sum problem. I have the following data entered. The sum
>> >total
>> > in excel =49.604
>> > When you add these up it should read 49.607
>> > What the heck is going on?
>> > Scott
>> > 1.802
>> > 2.337
>> > 1.942
>> > 1.330
>> > 0.885
>> > 1.910
>> > 1.780
>> > 2.927
>> > 2.413
>> > 2.617
>> > 1.297
>> > 0.522
>> > 2.453
>> > 2.582
>> > 2.388
>> > 1.453
>> > 1.751
>> > 0.794
>> > 0.769
>> > 2.170
>> > 1.689
>> > 2.391
>> > 2.007
>> > 1.265
>> > 1.081
>> > 0.821
>> > 1.761
>> > 2.470
>> > 0.000
>> > 0.000
>> > 0.000
>> >
>>
>>
>>
Niek
I hate to be a bother but the format doesn't work. Does checking the persion
button effect very much. Also with the information I have how do I use the
round function I can not seem to get it to work. I just want to sum that
column with the correct number. Sorry Hope you can help
Scott
"Niek Otten" wrote:
> It depends on what you require.
>
> If you don't want to lose any accuracy, format all your numbers as General
> and widen the column so you see all decimals. You may find that the numbers
> now look different from before.
>
> If you insist on calculating with 3 decimals, either use the ROUND()
> function for all of the numbers or apply Precision as displayed.
>
> --
> Kind regards,
>
> Niek Otten
>
> "scott" <[email protected]> wrote in message
> news:[email protected]...
> > Niek
> > I checked the persision and it said it may effect accuracey is this going
> > to
> > be a big problem i have allot of calulations going on envoling decimal
> > points
> > scott
> >
> > "Niek Otten" wrote:
> >
> >> http://www.mcgimpsey.com/excel/pennyoff.html
> >>
> >>
> >> --
> >> Kind regards,
> >>
> >> Niek Otten
> >>
> >> "scott" <[email protected]> wrote in message
> >> news:[email protected]...
> >> >I have a simple sum problem. I have the following data entered. The sum
> >> >total
> >> > in excel =49.604
> >> > When you add these up it should read 49.607
> >> > What the heck is going on?
> >> > Scott
> >> > 1.802
> >> > 2.337
> >> > 1.942
> >> > 1.330
> >> > 0.885
> >> > 1.910
> >> > 1.780
> >> > 2.927
> >> > 2.413
> >> > 2.617
> >> > 1.297
> >> > 0.522
> >> > 2.453
> >> > 2.582
> >> > 2.388
> >> > 1.453
> >> > 1.751
> >> > 0.794
> >> > 0.769
> >> > 2.170
> >> > 1.689
> >> > 2.391
> >> > 2.007
> >> > 1.265
> >> > 1.081
> >> > 0.821
> >> > 1.761
> >> > 2.470
> >> > 0.000
> >> > 0.000
> >> > 0.000
> >> >
> >>
> >>
> >>
>
>
>
Scott,
The numbers you see are not necessarily the actual values, whilst the SUM
works on the actual values. You can get it to SUM as seen with
=SUM(ROUND(A1:A31,3))
which is an array formula, it should be committed with Ctrl-Shift-Enter, not
just Enter.
--
HTH
Bob Phillips
(remove nothere from email address if mailing direct)
"scott" <[email protected]> wrote in message
news:[email protected]...
> Niek
> I hate to be a bother but the format doesn't work. Does checking the
persion
> button effect very much. Also with the information I have how do I use the
> round function I can not seem to get it to work. I just want to sum that
> column with the correct number. Sorry Hope you can help
> Scott
>
>
> "Niek Otten" wrote:
>
> > It depends on what you require.
> >
> > If you don't want to lose any accuracy, format all your numbers as
General
> > and widen the column so you see all decimals. You may find that the
numbers
> > now look different from before.
> >
> > If you insist on calculating with 3 decimals, either use the ROUND()
> > function for all of the numbers or apply Precision as displayed.
> >
> > --
> > Kind regards,
> >
> > Niek Otten
> >
> > "scott" <[email protected]> wrote in message
> > news:[email protected]...
> > > Niek
> > > I checked the persision and it said it may effect accuracey is this
going
> > > to
> > > be a big problem i have allot of calulations going on envoling decimal
> > > points
> > > scott
> > >
> > > "Niek Otten" wrote:
> > >
> > >> http://www.mcgimpsey.com/excel/pennyoff.html
> > >>
> > >>
> > >> --
> > >> Kind regards,
> > >>
> > >> Niek Otten
> > >>
> > >> "scott" <[email protected]> wrote in message
> > >> news:[email protected]...
> > >> >I have a simple sum problem. I have the following data entered. The
sum
> > >> >total
> > >> > in excel =49.604
> > >> > When you add these up it should read 49.607
> > >> > What the heck is going on?
> > >> > Scott
> > >> > 1.802
> > >> > 2.337
> > >> > 1.942
> > >> > 1.330
> > >> > 0.885
> > >> > 1.910
> > >> > 1.780
> > >> > 2.927
> > >> > 2.413
> > >> > 2.617
> > >> > 1.297
> > >> > 0.522
> > >> > 2.453
> > >> > 2.582
> > >> > 2.388
> > >> > 1.453
> > >> > 1.751
> > >> > 0.794
> > >> > 0.769
> > >> > 2.170
> > >> > 1.689
> > >> > 2.391
> > >> > 2.007
> > >> > 1.265
> > >> > 1.081
> > >> > 0.821
> > >> > 1.761
> > >> > 2.470
> > >> > 0.000
> > >> > 0.000
> > >> > 0.000
> > >> >
> > >>
> > >>
> > >>
> >
> >
> >
Scott
I don't get it. I copied/pasted your numbers into excel, came up with 49.607
Tools/Options/precision as displayed not checked.
Formatted as "general"
What formulas are you using to get the number in the column, and what
formula add them for you?
Beege
"scott" <[email protected]> wrote in message
news:[email protected]...
>I have a simple sum problem. I have the following data entered. The sum
>total
> in excel =49.604
> When you add these up it should read 49.607
> What the heck is going on?
> Scott
> 1.802
> 2.337
> 1.942
> 1.330
> 0.885
> 1.910
> 1.780
> 2.927
> 2.413
> 2.617
> 1.297
> 0.522
> 2.453
> 2.582
> 2.388
> 1.453
> 1.751
> 0.794
> 0.769
> 2.170
> 1.689
> 2.391
> 2.007
> 1.265
> 1.081
> 0.821
> 1.761
> 2.470
> 0.000
> 0.000
> 0.000
>
He has the display format at 3 dec places, so many numbers are probably
smaller, but the presentation is rounded up.
--
HTH
Bob Phillips
(remove nothere from email address if mailing direct)
"Beege" <[email protected]> wrote in message
news:[email protected]...
> Scott
>
> I don't get it. I copied/pasted your numbers into excel, came up with
49.607
>
> Tools/Options/precision as displayed not checked.
>
> Formatted as "general"
>
> What formulas are you using to get the number in the column, and what
> formula add them for you?
>
> Beege
>
>
> "scott" <[email protected]> wrote in message
> news:[email protected]...
> >I have a simple sum problem. I have the following data entered. The sum
> >total
> > in excel =49.604
> > When you add these up it should read 49.607
> > What the heck is going on?
> > Scott
> > 1.802
> > 2.337
> > 1.942
> > 1.330
> > 0.885
> > 1.910
> > 1.780
> > 2.927
> > 2.413
> > 2.617
> > 1.297
> > 0.522
> > 2.453
> > 2.582
> > 2.388
> > 1.453
> > 1.751
> > 0.794
> > 0.769
> > 2.170
> > 1.689
> > 2.391
> > 2.007
> > 1.265
> > 1.081
> > 0.821
> > 1.761
> > 2.470
> > 0.000
> > 0.000
> > 0.000
> >
>
>
Please be a bit more specific. What is the format? What do you see? Did you
widen the column? What do you mean with "whole number"? To see all the
digits or to see the integer part only (what math people would call a whole
number, strange enough)?
Please tell us where you get the numbers from (formulas? what formulas? what
values?), what the formatting string is, whether you widened the column,
what you see, what your SUM formula is, how you formatted that one, what you
see there, etc.
--
Kind regards,
Niek Otten
"scott" <[email protected]> wrote in message
news:[email protected]...
> Niek
> I hate to be a bother but the format doesn't work. Does checking the
> persion
> button effect very much. Also with the information I have how do I use the
> round function I can not seem to get it to work. I just want to sum that
> column with the correct number. Sorry Hope you can help
> Scott
>
>
> "Niek Otten" wrote:
>
>> It depends on what you require.
>>
>> If you don't want to lose any accuracy, format all your numbers as
>> General
>> and widen the column so you see all decimals. You may find that the
>> numbers
>> now look different from before.
>>
>> If you insist on calculating with 3 decimals, either use the ROUND()
>> function for all of the numbers or apply Precision as displayed.
>>
>> --
>> Kind regards,
>>
>> Niek Otten
>>
>> "scott" <[email protected]> wrote in message
>> news:[email protected]...
>> > Niek
>> > I checked the persision and it said it may effect accuracey is this
>> > going
>> > to
>> > be a big problem i have allot of calulations going on envoling decimal
>> > points
>> > scott
>> >
>> > "Niek Otten" wrote:
>> >
>> >> http://www.mcgimpsey.com/excel/pennyoff.html
>> >>
>> >>
>> >> --
>> >> Kind regards,
>> >>
>> >> Niek Otten
>> >>
>> >> "scott" <[email protected]> wrote in message
>> >> news:[email protected]...
>> >> >I have a simple sum problem. I have the following data entered. The
>> >> >sum
>> >> >total
>> >> > in excel =49.604
>> >> > When you add these up it should read 49.607
>> >> > What the heck is going on?
>> >> > Scott
>> >> > 1.802
>> >> > 2.337
>> >> > 1.942
>> >> > 1.330
>> >> > 0.885
>> >> > 1.910
>> >> > 1.780
>> >> > 2.927
>> >> > 2.413
>> >> > 2.617
>> >> > 1.297
>> >> > 0.522
>> >> > 2.453
>> >> > 2.582
>> >> > 2.388
>> >> > 1.453
>> >> > 1.751
>> >> > 0.794
>> >> > 0.769
>> >> > 2.170
>> >> > 1.689
>> >> > 2.391
>> >> > 2.007
>> >> > 1.265
>> >> > 1.081
>> >> > 0.821
>> >> > 1.761
>> >> > 2.470
>> >> > 0.000
>> >> > 0.000
>> >> > 0.000
>> >> >
>> >>
>> >>
>> >>
>>
>>
>>
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks