Percentages

[Manny74]

Hello All!

I can't remember how to utilize percentages in Excel.

For example, I have 10 dummy clients, 2 dummy clients have viral load results equal to or less than 20....

I know basic math would be 2/10 * 100 = 20 (20%)

So I Excel, I entered this in a cell: =2/10*100

And I got 20....

How else can I calculate this in Excel?

Thanks in Advance, Manny

CLIENT FIRST NAME	CLIENT LAST NAME	VIRAL LOAD RESULT
JOHN	DOE	<20
JANE	DOE	<20
PETER	DOE	51
JOAN	SMITH	55
MARIA	JOHNSON	60
DEAN	DOE	65
JANET	DOE	70
JEAN	THOMAS	75
DAVID	JONES	80
ANA	AVILA	85
TOTAL CLIENTS	10
PERCENT OF CLIENTS WITH VIRAL LOAD EQUAL TO OR LESS THAN 20	20

<colgroup><col width="135" style="width: 101pt; mso-width-source: userset; mso-width-alt: 4937;"> <col width="131" style="width: 98pt; mso-width-source: userset; mso-width-alt: 4790;"> <col width="139" style="width: 104pt; mso-width-source: userset; mso-width-alt: 5083;"> <tbody> </tbody>

 

[BigDat6CC]

Hello All!

I can't remember how to utilize percentages in Excel.

For example, I have 10 dummy clients, 2 dummy clients have viral load results equal to or less than 20....

I know basic math would be 2/10 * 100 = 20 (20%)

So I Excel, I entered this in a cell: =2/10*100

And I got 20....

How else can I calculate this in Excel?

Thanks in Advance, Manny

CLIENT FIRST NAME	CLIENT LAST NAME	VIRAL LOAD RESULT
JOHN	DOE	<20
JANE	DOE	<20
PETER	DOE	51
JOAN	SMITH	55
MARIA	JOHNSON	60
DEAN	DOE	65
JANET	DOE	70
JEAN	THOMAS	75
DAVID	JONES	80
ANA	AVILA	85
TOTAL CLIENTS	10
PERCENT OF CLIENTS WITH VIRAL LOAD EQUAL TO OR LESS THAN 20	20

<tbody>
</tbody>

Hello Manny
Could John and Jane's Viral Load Results be absolute numeric values instead of "<20"?

 

[Manny74]

Yes, an absolute number (20) could be used...

 

[BigDat6CC]

Hello Manny

Assuming your Results are in column C, then this formula is worth a try: =COUNTIFS(C2:C11,"<=20")/COUNT(C2:C11)