In cell where you want percentage write formula
=100*(COUNTIF(D:D;"Pass")/COUNTA(D:D))
and set cell format to percentage. D:D here is reference
to Your pass/fail column change it to your results column.
Toomas
----- Original Message -----
From: "Mick Fitzpatrick" <[log in to unmask]>
> Hello
>
>
> I have a spreadsheet of pupils showing when they pass or fail their driving
> test. It is a basic sheet with their name in one column, next the date, then
> next to that the word pass or fail as appropiate.
>
> What I would like to do is have make some kinda calculation from the
> 'pass/fail column' and convert that into a percentage. In other words: If I
> have had 10 pupils and 7 have passed and 3 have failed then one calculation
> will be 70% and the other 30% (hopefully showing the percent symbol as
> well). If it's not possible to calculate the words 'pass' or 'fail' I can
> change those words to an appropiate number.
>
> Is that possible?
>
The NOSPIN Group is now offering Free PC Tech
support at our newest website:
http://freepctech.com
|