Percentage Formula in Excel

[Mike_GSP]

Help! Trying to write a formula that will calculate a percent of accuracy.
Here's the data... Created 205 widgets, there were 9 errors, % of accuracy
is 95.61%. the math is basic...
x/100 = 9/205
205x - 900
x=900/205
x= 4.39024 %
100% - 4.390% = 95.61%
How do I write a formula to calculate this. I tried....
=[(C4/B4)=(x/100)]
where Cell C4 is the 205 widgets and Cell B4 is the 9 errors.

I found a formula to find the 4.39% - the percent of error, but can I have
the percent of accuracy with adding a column? If not I guess I can always
add a column for that extra step and then hide it from print view.

 

[Jacob Skaria]

=100-(B4*100)/C4

If this post helps click Yes

 

[Shane Devenshire]

Try

=(C4-B4)/C4

 

[FSt1]

hi
with 205 in B4 and 9 in C4...
=1-(C4/B4)
format as percent
this would equal 95.61%

regards
FSt1