Hello
First thing ... thank you for the info on showing a minus figure as a zero
... it is now working
I have another question please.
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?
I hope I have made myself clear ... I can put an example on the web if this
will help?
TIA ... Mick
The NOSPIN Group is now offering Free PC Tech
support at our newest website:
http://freepctech.com
|