per centages and sums error
 

In excel 2003, I need to calculate per centages of a number, and add the
sums of each together. The results may be off a penny or two each time. Can
someone help?
example: if you multiple $4,675.00 by .05%, and then by .5%
$4,675.00
x .05% = $2.34
x .5% = $23.38

sum $25.71

I assume it is a formatting issue, but I am at a loss. Seems like it
should be simple. Thanks for any help!
--
DebC

per centages and sums error
 

Hi,
When applying the % use the formula as follow, change cell # to fit your needs

=ROUND(+K5*J7,2)

If this was helpful please say yes, thanks

"DebC" wrote:

In excel 2003, I need to calculate per centages of a number, and add the
sums of each together. The results may be off a penny or two each time. Can
someone help?
example: if you multiple $4,675.00 by .05%, and then by .5%
$4,675.00
x .05% = $2.34
x .5% = $23.38

sum $25.71

I assume it is a formatting issue, but I am at a loss. Seems like it
should be simple. Thanks for any help!
--
DebC

per centages and sums error
 

Thank you so much, Eduardo! This was very helpful.
--
DebC


"Eduardo" wrote:

Hi,
When applying the % use the formula as follow, change cell # to fit your needs

=ROUND(+K5*J7,2)

If this was helpful please say yes, thanks

"DebC" wrote:

In excel 2003, I need to calculate per centages of a number, and add the
sums of each together. The results may be off a penny or two each time. Can
someone help?
example: if you multiple $4,675.00 by .05%, and then by .5%
$4,675.00
x .05% = $2.34
x .5% = $23.38

sum $25.71

I assume it is a formatting issue, but I am at a loss. Seems like it
should be simple. Thanks for any help!
--
DebC

per centages and sums error
 

Thanks, Glenn. I appreciate your help very much.
--
DebC


"Glenn" wrote:

DebC wrote:
In excel 2003, I need to calculate per centages of a number, and add the
sums of each together. The results may be off a penny or two each time. Can
someone help?
example: if you multiple $4,675.00 by .05%, and then by .5%
$4,675.00
x .05% = $2.34
x .5% = $23.38

sum $25.71

I assume it is a formatting issue, but I am at a loss. Seems like it
should be simple. Thanks for any help!

Wrap your formulas with ROUND().

=ROUND(A1*.05%,2)

per centages and sums error
 

What does the + sign do in that formula, Eduardo?
Why not just =ROUND(K5*J7,2) ?
--
David Biddulph

"Eduardo" wrote in message
...
Hi,
When applying the % use the formula as follow, change cell # to fit your
needs

=ROUND(+K5*J7,2)

If this was helpful please say yes, thanks

"DebC" wrote:

In excel 2003, I need to calculate per centages of a number, and add the
sums of each together. The results may be off a penny or two each time.
Can
someone help?
example: if you multiple $4,675.00 by .05%, and then by .5%
$4,675.00
x .05% = $2.34
x .5% = $23.38

sum $25.71

I assume it is a formatting issue, but I am at a loss. Seems like it
should be simple. Thanks for any help!
--
DebC

per centages and sums error
 

DebC wrote:
In excel 2003, I need to calculate per centages of a number, and add the
sums of each together. The results may be off a penny or two each time. Can
someone help?
example: if you multiple $4,675.00 by .05%, and then by .5%
$4,675.00
x .05% = $2.34
x .5% = $23.38

sum $25.71

I assume it is a formatting issue, but I am at a loss. Seems like it
should be simple. Thanks for any help!

Wrap your formulas with ROUND().

=ROUND(A1*.05%,2)