Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Percentage
What would the calculation be if I needed the % of the type of following
situation: 5 patients discharged, 2 of which needed charge corrections. What is the total percent that was correct and the total percent that was incorrect. Thanks. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Percentage
See other post
-- __________________________________ HTH Bob "Dawnavyn" wrote in message ... What would the calculation be if I needed the % of the type of following situation: 5 patients discharged, 2 of which needed charge corrections. What is the total percent that was correct and the total percent that was incorrect. Thanks. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Percentage
A percentage is just a ratio
So 2 out of 5 needed correction: ratio = 2/5 = 0.4 Generally we like to see this as 40%, so format the cell with % tool If this is in C1, then the percentage correct =1-C1 again formatted with % tool best wishes -- Bernard V Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme remove caps from email "Dawnavyn" wrote in message ... What would the calculation be if I needed the % of the type of following situation: 5 patients discharged, 2 of which needed charge corrections. What is the total percent that was correct and the total percent that was incorrect. Thanks. |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Percentage
================================================== ===========
About percentages in Excel Niek Otten, July 26 2006 In Excel, percentages are stored as fractions; 15% is stored as 0.15, 100% as 1. That makes it easy to calculate with; just multiply a number with a percentage and you get what you need. No need to divide/multiply by 100. In fact, if you see a calculation with percentages which has the number 100 somewhere in the formula; be very careful, it might be wrong or at least use percentages in a way they werent meant to be used in Excel. The conversion to a fraction happens automatically if you enter the % sign: if you enter €ś15%€ť (without the quotes) the value will be 0.15 and it will be displayed as 15%. If you then enter 12 in the same cell, two things can happen: It will be the number 12 or 12%. What happens in your case depends on a setting: ToolsOptions, Edit tab, €śEnable automatic percent entry€ť (only Excel2000 and newer). All built-in functions of Excel and all the functions in Analysis Toolpak use this representation of percentages: be careful when supplying parameters to these functions; never use whole numbers (like 8), always use fractions (like 0.08 or, even better, 8%). Frequently Asked Questions: Q: I have A1 and B1. How do I get C1 to show B1 as a percentage of A1? A: Formula in C1: =B1/A1, Format as % Q: I have A1 and B1. How do I show the difference as a percentage in C1? A: As a percentage of A1: =(B1-A1)/A1, Format as % As a percentage of B1: =(B1-A1)/B1, Format as % Q: In A1 I have he end price. In B1 I have the VAT percentage, entered like 15% What is the formula to find the base price, excluding VAT? A: =A1/(1+A2) ================================================== =========== -- Kind regards, Niek Otten Microsoft MVP - Excel "Dawnavyn" wrote in message ... What would the calculation be if I needed the % of the type of following situation: 5 patients discharged, 2 of which needed charge corrections. What is the total percent that was correct and the total percent that was incorrect. Thanks. |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Percentage
Hi,
Suppose you have entered Correction in column A for discharges the needed to be corrected and entered Correct for those that need no correction. Then you could use a formula like =COUNTIF(A1:A5,"Correct")/COUNTA(A1:A5) to find the percent correct and if this formula is in B1, in B2 you could enter =1-B1 for the percent needing correction. -- If this helps, please click the Yes button Cheers, Shane Devenshire "Dawnavyn" wrote: What would the calculation be if I needed the % of the type of following situation: 5 patients discharged, 2 of which needed charge corrections. What is the total percent that was correct and the total percent that was incorrect. Thanks. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
percentage | Excel Discussion (Misc queries) | |||
Add a percentage | Excel Discussion (Misc queries) | |||
percentage? | Excel Discussion (Misc queries) | |||
Calculating a percentage with the end percentage in mind | Excel Discussion (Misc queries) | |||
Bar Chart depicting the "percentage of another percentage(less than 100)" | Charts and Charting in Excel |