LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 10
Default Rate of Failure Formula

Here is the general concept.

I have 56 Televisions. The month is currently april and 3 of those 56 have
failed(quit, don't work). I am wanting to try and find a quick and easy
formula that gives me the rate of failure. I know it is probably something
simple, though it seems all brain power has left me on a friday.

56 Television
3 Quit
4 Months into the year
Televisions are 1997 or older
2 different kinds -- Magnavox and Phillips.

I have a spreadsheet all laid out, though I just can't seem to think of the
way to tie it all together. I would like to show the rate of failure between
the two brands as well. 2 of those 3 are Magnavox's, and the other 1 is
Phillips. Any help would be -greatly- appreciated!

Thanks ahead of time!
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Basic Future Value Formula & Interest Rate Formula Peter Excel Discussion (Misc queries) 2 November 12th 06 04:23 AM
Prime rate/Liber rate into sheet automatically? Nixt Excel Discussion (Misc queries) 0 January 21st 06 09:49 PM
Real RATE of return using =RATE illusive, inflation adjusted inflo Pro - Land Excel Worksheet Functions 4 November 1st 05 03:06 AM
Rate formula Joanne Excel Worksheet Functions 0 July 7th 05 05:59 PM
APR - Annual Percentage Rate to Actual Interest Rate Safu Excel Worksheet Functions 9 May 18th 05 05:03 AM


All times are GMT +1. The time now is 06:07 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"