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