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