11th May 2009, 12:51 PM
|
Member
|
|
Join Date: Aug 2007
Posts: 446
|
|
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?
|