Firstly Hi to you all,
My name is Mike and I am a Captain of a Bowls Club this year. I have created a spreadsheet in Excell 2010 to log all our results for the coming year which consists of information to show Win/Lost/Drawn and the score For and against and difference between these two entries.
This is the formula I am using to show the whether we have won/lost/drawn =IF(E13>0,"Won",IF(E13<0,"Lost","Draw"))
My problem is that all the cells are currently showing "0" as there are no results yet and therefore the formula shows Drawn" all the way down. Is there a way of hiding this until a result is input?
I have no idea how this is done so if anyone can help I would appreciate it.
Regards
Mike
Bookmarks