Excel percentage problem

  • Thread starter Cheezhedheiking
  • Start date
C

Cheezhedheiking

Hi!
My problem is in finding a formula for percentages. I hope I mak
this clear..
I need to create a graph showing the failure rate of 4 differen
types of relays going back 8 years and projecting 5 years in th
future.
Instuctructins include equating the number of relays to the bas
10,000. The first set of relay failures have to be divided by 4,and
next two sets are divided by 2. Using this information I need to sho
the percentage of failures per relay/per year.
Any help would be ggreatly appreciated, as I have yet to even com
close to anything that resembles a correct formula or answer. Thank yo
for your time, have a wonderful week
 
B

BrianB

equating the number of relays to the base 10,000
Click to expand...

The % failure rate is the total failures per 100
i.e. failures divided by total production times 100.
=failures/production * 100

To get failure rate per 10,000 use
=failures/production * 1000
 
C

Cheezhedheiking

Hi!
Thank you so much! I was making it much harder than it had to be.
thought I would have to make a formula like ones I had seen befor
(Like 1$6$)
You made this so much easier for me! Thanks again and have an awesom
week!
LoriLe
 
Top