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?

IF statements usually tidy up that.

Something like:

=IF (A1=0,"",formula)

Where A1 is your cell containing the rating
and Formula is what you have in the cell at the moment