#1
|
|||
|
|||
![]() 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? |
#2
|
|||
|
|||
![]() 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 |
![]() |
Thread Tools | Search this Thread |
Display Modes | |
|
|