View Single Post
  #1  
Old 11th May 2009, 01:51 PM
thorns thorns is offline
Member
 
Join Date: Aug 2007
Posts: 446
Default Supressing spreadsheet data

I am just creating a new ratings sheet and am after some help on how to supress some cells. For instance I have set it up to calculate prices derived from the final ratings. Now there is a time where I some horses end up with a zero rating, and because of this it come up with for example:

#DIV/0!

Is it possible to set the sheet up so that in these occurences, it just displays a blank cell instead of teh above text?
Reply With Quote