Hi David,
You're exactly right. Basically it's a chain of calculation. I get the
percentage from another set of numbers of division and format the cell as
percentage and I'm using the percentage to calculate something else by
multiplication and format the cell with 2 digital decimal.

Since I don't have the exact percentage and it changes over time according
to the previous set of number. Are there better to accomplish this?

Thanks,
Neon520

"David Biddulph" wrote:

You haven't explained where your percentages come from, but I assume that
you haven't done what you were told to do earlier, which is to display the
numbers to a greater precision. My guess is that you dont have exactly 77%,
but that you've displayed it only to the nearest 1%.
--
David Biddulph

"Neon520" wrote in message
...
Hi David,

Sorry for the unclear message.
Here is what I need to get done.

Eventually, I need to have in 2 digit decimals.
Total Hour: 16
Let's say here is the percentage, (keep in mind that these percentage will
change base on something else)

Percentage Result
47% 7.55
31% 4.96
12% 1.99
3% 0.54
6% 0.97

The number in the result column should add up to "16"- the original
number,
but it does not, it come up with 16.01.

Now that I look at it carefully, I notice that the percentages don't even
add up to 100, it' 99. Why?
I achieve the percentage by dividing a set of number by one big number,
they
should be 100. and it shows 100 when I do =sum(column), but adding the
number
manually, it's NOT.

Can someone tell me Why and How to fix this?

Lots of thank.

Neon520



"David Biddulph" wrote:

I don't think we understand what you are trying to achieve.

If you want an exact answer (within the 15 digit precision of Excel's
calculations), then don't round. If you want to round, then use the
ROUND
function. If you don't want either of those options, perhaps you could
explain clearly whay you *do* want?

Perhaps you can give an example of your problem?
--
David Biddulph

"Neon520" wrote in message
...
Hi Niek,

I was trying the Round function that you suggested, and hoping that it
will
help, but unfortunately it doesn't, because after all when using Round
function it will round up the way we use Cell Formatting. So it still
end
up
short by 1 or over by 1.

Any other ideas?

Thank you,
Neon520


"Niek Otten" wrote:

use something like

=ROUND(A1,2)/ROUND(A6,2)

if you use 2 decimals.

An alternative is ToolsOptionsCalculation tab, check Precision as
displayed.
But then it happens for all your data, so think about wheter that is
what
you require.


--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"Neon520" wrote in message
...
Yes, I do realize that. It's just a matter of formatting the cell,
but
how
can I limit the percentage so that it will calculate correctly when
I
verify
it manually back.

I just want to get it right every time without having to worry what
percentage it is or what the hours it is.

Thanks for you fast reply.

Neon520

"Niek Otten" wrote:

If you format A1 as General and widen the column, you'll probably
discover
that there are decimals involved that you didn't see first.

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"Neon520" wrote in message
...
Hi everyone,

I have a problem with percentage calculation here.
I need to calculate the numbers of 5 different items base on the
Total
of
all 5 items, so what I did is using the amount for each item,
let's
say
item#1 in A1 divide by the Total amount of items in A6, I know
that
this
will
give me the percentage of item#1, and I do the same for the rest
of
the
items. If let's say there is a Total amount of Hours that put
into
making
these items I need to distribute this total hour according to the
percentage
that I had calculated, I would use the total hour to multiply by
the
percentage for each item number, right?

But the problem that I'm having is when I try to verify the total
hour
by
sum of the hour for each item back manually; some time it's short
by
1
and
sometime it's over by 1.
I didn't notice this at first when I do =sum(B1:B5), but when I
pick
up
the
number manually instead, I notice that it's off by 1 number
sometime.

What can I do to prevent this from happening? HELP!!!