Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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) |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
SUMS | Excel Discussion (Misc queries) | |||
How to add previous sums in a column to current sums in a column? | Excel Worksheet Functions | |||
Sums | Excel Discussion (Misc queries) | |||
Sums | Excel Discussion (Misc queries) | |||
Sums | Excel Discussion (Misc queries) |