Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Percentile formula
I need help creating a spreadsheet in excel that would give me the following
total percent for the following information: If there is a total of 3 dogs and 2 of them needed surgery what is the percentage between the origianl 3 dogs and the 2 that needed surgery? Another example is .... 5 total patients were discharged and 3 of them needed chart corrections. What is the percentage of the two. any information would be greatly appreciated. Thanks. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Percentile formula
=num_Needing_surgery/total_Num formatted as a percentage -- __________________________________ HTH Bob "Dawnavyn" wrote in message ... I need help creating a spreadsheet in excel that would give me the following total percent for the following information: If there is a total of 3 dogs and 2 of them needed surgery what is the percentage between the origianl 3 dogs and the 2 that needed surgery? Another example is .... 5 total patients were discharged and 3 of them needed chart corrections. What is the percentage of the two. any information would be greatly appreciated. Thanks. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Display Percentile | Excel Worksheet Functions | |||
Sumproduct and Percentile | Excel Worksheet Functions | |||
Conditional Percentile | Excel Discussion (Misc queries) | |||
percentile | Excel Worksheet Functions | |||
Percentile function | Excel Worksheet Functions |