View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
FSt1 FSt1 is offline
external usenet poster
 
Posts: 3,942
Default Percentage Formula in Excel

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

regards
FSt1

"Mike_GSP" wrote:

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.