Percentage formula

Ok this is probably a no brainer, so here goes

I have a simple spread sheet where i need a formula to work out a percentage.


eg total cases 35246 number of errors 3. what percentage is the 3 of the total cases and what is the formula required to reflect the answer.

Hi UKPhoenix,

If the number 3 is in A1, and 35246 in B1, then use the formula:

=A1/B1

Format that cell as a percentage and adjust the decimal places to 4, 5 or whatever you wish.

= 3/35246 and format as percent with some extra decimals.