Pass or Fail problem

[Gaz_Royal]

Ok firstly thanks for reading this post I really do need some help

I have a row of 5 codes for individual marks - P for Pass and F for Fail. In the last column I have the overall result - P if all individual results were P and F if any of the 5 results were an F.

My problem is that if no data has been entered the final result defaults to an F for Fail when in fact I would like it to show blank or space.

I think this problem is something to do with NULL value but I'm not sure what to do to resolve this. Any help or guidance will be greatly appreciated. Cheers.

 

[Gaz_Royal]

Ian,

You were absolutely correct....spaces do seem to exist in every cell until F or P are entered. For the rows where no results are entered (i.e. all 8 cells contain spaces) then the default is F until I delete one of the cell contents.