View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Mike_GSP Mike_GSP is offline
external usenet poster
 
Posts: 1
Default Percentage Formula in Excel

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.