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!!!