working out a percentage

[galvinpaddy]

morning happy campers,

Forgive the potentially daft question - having some serious brain blocks

I have 67 units returned to me.
52 of these are down to kitting errors and 17 are due to processing errors.

How do i show 67 as 100% and the 52 & 17 as a percentage of these?

Kind regards

galvinpaddy

[hemesh]

I think returned units should be 69.
and calculation should be 52/69 and 17/69 format cell as %

[Pete_UK]

It's just 52/67, formatted as a percentage, and 17/67 for the processing errors. Note that the two numbers add up to 69, so the two percentages will add up to more than 100% - presumably two of the returns had both types of errors.

Hope this helps.

Pete