Calculate percentage

[t1o9n9y1]

I am trying to work out a percentage...

COUNT	ISSUES	TOTAL
13	1	8%

<tbody>
</tbody>

This is what I'm currently getting, however I want to flip it. So that the 8% in the total
column displays 92% instead.

So the count of 13 is 100%, minus the issues of 1 which is 8% which gives me a total of 92%.

How would I go about this?

Thanks for any help.

 

[jim may]

Excel 2010

	A	B	C
1	COUNT	ISSUES	TOTAL
2	13	1	92%

<colgroup><col style="width: 25pxpx"><col><col><col></colgroup><thead>
</thead><tbody>
</tbody>

Sheet1​

Worksheet Formulas Cell Formula C2 =1-(B2/A2) <thead> </thead><tbody> </tbody>

<tbody>
</tbody>

 

[gaz_chops]

Try

=1-B1/A1