Looking for ideas why my =sum is not working ... it is coming up a
penny short of the numbers in the range it is set for.
The spreadsheet is set up to have numbers in column b times by number
in colum c and then show calculation in column d
This part works fine but when you sum column d down it drops a penny.
It should be a round number like $75.00 but instead it gives me $69.99
All totals in column d are to the dollar with no cents.
There is however a selection for column b that is a decimal such as .
6666. Could this be the culprit and if so how can it be corrected?
I have to have the .6666 or .3333 etc. numbers to give me the
calculation for the $ amount required in column d of the base amount
in column C.... i.e. .2222 of $45 gives $10. which is what is the
correct amount.

See this:

http://mcgimpsey.com/excel/pennyoff.html

--
Biff
Microsoft Excel MVP


"nip" <gbreath@gmail.com> wrote in message
news:93bcabde-e34f-408c-9240-d45f25933cc3@a3g2000prm.googlegroups.com...
> Looking for ideas why my =sum is not working ... it is coming up a
> penny short of the numbers in the range it is set for.
> The spreadsheet is set up to have numbers in column b times by number
> in colum c and then show calculation in column d
> This part works fine but when you sum column d down it drops a penny.
> It should be a round number like $75.00 but instead it gives me $69.99
> All totals in column d are to the dollar with no cents.
> There is however a selection for column b that is a decimal such as .
> 6666. Could this be the culprit and if so how can it be corrected?
> I have to have the .6666 or .3333 etc. numbers to give me the
> calculation for the $ amount required in column d of the base amount
> in column C.... i.e. .2222 of $45 gives $10. which is what is the
> correct amount.

Check out John McGimpsey's site for the why and possible workarounds.

http://www.mcgimpsey.com/excel/pennyoff.html


Gord Dibben MS Excel MVP

On Wed, 3 Sep 2008 14:58:24 -0700 (PDT), nip <gbreath@gmail.com> wrote:

>Looking for ideas why my =sum is not working ... it is coming up a
>penny short of the numbers in the range it is set for.
>The spreadsheet is set up to have numbers in column b times by number
>in colum c and then show calculation in column d
>This part works fine but when you sum column d down it drops a penny.
>It should be a round number like $75.00 but instead it gives me $69.99
>All totals in column d are to the dollar with no cents.
>There is however a selection for column b that is a decimal such as .
>6666. Could this be the culprit and if so how can it be corrected?
>I have to have the .6666 or .3333 etc. numbers to give me the
>calculation for the $ amount required in column d of the base amount
>in column C.... i.e. .2222 of $45 gives $10. which is what is the
>correct amount.

On Sep 3, 3:32*pm, "T. Valko" <biffinp...@comcast.net> wrote:
> See this:
>
> http://mcgimpsey.com/excel/pennyoff.html
>
> --
> Biff
> Microsoft Excel MVP
>
> "nip" <gbre...@gmail.com> wrote in message
>
> news:93bcabde-e34f-408c-9240-d45f25933cc3@a3g2000prm.googlegroups.com...
>
>
>
> > Looking for ideas why my =sum is not working ... it is coming up a
> > penny short of the numbers in the range it is set for.
> > The spreadsheet is set up to have numbers in column b times by number
> > in colum c and then show calculation in column d
> > This part works fine but when you sum column d down it drops a penny.
> > It should be a round number like $75.00 but instead it gives me $69.99
> > All totals in column d are to the dollar with no cents.
> > There is however a selection for column b that is a decimal such as .
> > 6666. *Could this be the culprit and if so how can it be corrected?
> > I have to have the .6666 or .3333 etc. numbers to give me the
> > calculation for the $ amount required in column d of the base amount
> > in column C.... *i.e. .2222 of $45 gives $10. which is what is the
> > correct amount.- Hide quoted text -
>
> - Show quoted text -

Thanks all the =round solves the issue - for now