View Full Version : Supressing spreadsheet data

11th May 2009, 12:51 PM
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:


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

11th May 2009, 01:41 PM
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