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
[TABLE="width: 303"]
<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>[TR]
[TD="class: xl65, width: 135, bgcolor: transparent"]CLIENT FIRST NAME[/TD]
[TD="class: xl65, width: 131, bgcolor: transparent"]CLIENT LAST NAME[/TD]
[TD="class: xl66, width: 139, bgcolor: transparent"]VIRAL LOAD RESULT[/TD]
[/TR]
[TR]
[TD="class: xl67, bgcolor: transparent"]JOHN[/TD]
[TD="class: xl67, bgcolor: transparent"]DOE[/TD]
[TD="class: xl68, bgcolor: transparent"]<20[/TD]
[/TR]
[TR]
[TD="class: xl67, bgcolor: transparent"]JANE[/TD]
[TD="class: xl67, bgcolor: transparent"]DOE[/TD]
[TD="class: xl68, bgcolor: transparent"]<20[/TD]
[/TR]
[TR]
[TD="class: xl67, bgcolor: transparent"]PETER[/TD]
[TD="class: xl67, bgcolor: transparent"]DOE[/TD]
[TD="class: xl68, bgcolor: transparent"]51[/TD]
[/TR]
[TR]
[TD="class: xl67, bgcolor: transparent"]JOAN[/TD]
[TD="class: xl67, bgcolor: transparent"]SMITH[/TD]
[TD="class: xl68, bgcolor: transparent"]55[/TD]
[/TR]
[TR]
[TD="class: xl67, bgcolor: transparent"]MARIA[/TD]
[TD="class: xl67, bgcolor: transparent"]JOHNSON[/TD]
[TD="class: xl68, bgcolor: transparent"]60[/TD]
[/TR]
[TR]
[TD="class: xl67, bgcolor: transparent"]DEAN[/TD]
[TD="class: xl67, bgcolor: transparent"]DOE[/TD]
[TD="class: xl68, bgcolor: transparent"]65[/TD]
[/TR]
[TR]
[TD="class: xl67, bgcolor: transparent"]JANET[/TD]
[TD="class: xl67, bgcolor: transparent"]DOE[/TD]
[TD="class: xl68, bgcolor: transparent"]70[/TD]
[/TR]
[TR]
[TD="class: xl67, bgcolor: transparent"]JEAN[/TD]
[TD="class: xl67, bgcolor: transparent"]THOMAS[/TD]
[TD="class: xl68, bgcolor: transparent"]75[/TD]
[/TR]
[TR]
[TD="class: xl67, bgcolor: transparent"]DAVID[/TD]
[TD="class: xl67, bgcolor: transparent"]JONES[/TD]
[TD="class: xl68, bgcolor: transparent"]80[/TD]
[/TR]
[TR]
[TD="class: xl67, bgcolor: transparent"]ANA[/TD]
[TD="class: xl67, bgcolor: transparent"]AVILA[/TD]
[TD="class: xl68, bgcolor: transparent"]85[/TD]
[/TR]
[TR]
[TD="class: xl67, bgcolor: transparent"] [/TD]
[TD="class: xl67, bgcolor: transparent"] [/TD]
[TD="class: xl68, bgcolor: transparent"] [/TD]
[/TR]
[TR]
[TD="class: xl69, bgcolor: transparent"]TOTAL CLIENTS[/TD]
[TD="class: xl70, bgcolor: transparent"]10[/TD]
[TD="class: xl64, bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="class: xl71, width: 135, bgcolor: transparent"]PERCENT OF CLIENTS WITH VIRAL LOAD EQUAL TO OR LESS THAN 20[/TD]
[TD="class: xl70, bgcolor: transparent"]20[/TD]
[TD="class: xl68, bgcolor: transparent"] [/TD]
[/TR]
</tbody>[/TABLE]
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
[TABLE="width: 303"]
<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>[TR]
[TD="class: xl65, width: 135, bgcolor: transparent"]CLIENT FIRST NAME[/TD]
[TD="class: xl65, width: 131, bgcolor: transparent"]CLIENT LAST NAME[/TD]
[TD="class: xl66, width: 139, bgcolor: transparent"]VIRAL LOAD RESULT[/TD]
[/TR]
[TR]
[TD="class: xl67, bgcolor: transparent"]JOHN[/TD]
[TD="class: xl67, bgcolor: transparent"]DOE[/TD]
[TD="class: xl68, bgcolor: transparent"]<20[/TD]
[/TR]
[TR]
[TD="class: xl67, bgcolor: transparent"]JANE[/TD]
[TD="class: xl67, bgcolor: transparent"]DOE[/TD]
[TD="class: xl68, bgcolor: transparent"]<20[/TD]
[/TR]
[TR]
[TD="class: xl67, bgcolor: transparent"]PETER[/TD]
[TD="class: xl67, bgcolor: transparent"]DOE[/TD]
[TD="class: xl68, bgcolor: transparent"]51[/TD]
[/TR]
[TR]
[TD="class: xl67, bgcolor: transparent"]JOAN[/TD]
[TD="class: xl67, bgcolor: transparent"]SMITH[/TD]
[TD="class: xl68, bgcolor: transparent"]55[/TD]
[/TR]
[TR]
[TD="class: xl67, bgcolor: transparent"]MARIA[/TD]
[TD="class: xl67, bgcolor: transparent"]JOHNSON[/TD]
[TD="class: xl68, bgcolor: transparent"]60[/TD]
[/TR]
[TR]
[TD="class: xl67, bgcolor: transparent"]DEAN[/TD]
[TD="class: xl67, bgcolor: transparent"]DOE[/TD]
[TD="class: xl68, bgcolor: transparent"]65[/TD]
[/TR]
[TR]
[TD="class: xl67, bgcolor: transparent"]JANET[/TD]
[TD="class: xl67, bgcolor: transparent"]DOE[/TD]
[TD="class: xl68, bgcolor: transparent"]70[/TD]
[/TR]
[TR]
[TD="class: xl67, bgcolor: transparent"]JEAN[/TD]
[TD="class: xl67, bgcolor: transparent"]THOMAS[/TD]
[TD="class: xl68, bgcolor: transparent"]75[/TD]
[/TR]
[TR]
[TD="class: xl67, bgcolor: transparent"]DAVID[/TD]
[TD="class: xl67, bgcolor: transparent"]JONES[/TD]
[TD="class: xl68, bgcolor: transparent"]80[/TD]
[/TR]
[TR]
[TD="class: xl67, bgcolor: transparent"]ANA[/TD]
[TD="class: xl67, bgcolor: transparent"]AVILA[/TD]
[TD="class: xl68, bgcolor: transparent"]85[/TD]
[/TR]
[TR]
[TD="class: xl67, bgcolor: transparent"] [/TD]
[TD="class: xl67, bgcolor: transparent"] [/TD]
[TD="class: xl68, bgcolor: transparent"] [/TD]
[/TR]
[TR]
[TD="class: xl69, bgcolor: transparent"]TOTAL CLIENTS[/TD]
[TD="class: xl70, bgcolor: transparent"]10[/TD]
[TD="class: xl64, bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="class: xl71, width: 135, bgcolor: transparent"]PERCENT OF CLIENTS WITH VIRAL LOAD EQUAL TO OR LESS THAN 20[/TD]
[TD="class: xl70, bgcolor: transparent"]20[/TD]
[TD="class: xl68, bgcolor: transparent"] [/TD]
[/TR]
</tbody>[/TABLE]