I am trying to build a workbook to look after a pool league/knockout
tournament for my local community. The result comes out in a sorted list
showing wins, draws etc. my problem is when I enter a letter (DW) for a
Default Win (opponent did not turn up) in the result card as opposed to the
frames won the formula =IF(I4($B$2/2),1,0) [where $B$2/2 = number of frames
in a match divided by 2 i.e. more than this and you win the game as a whole]
if the relst is more than then I want the value of 1 which represents 1 win,
if it is less then I want the value of zero. However, when a DW for default
win (which gets the player a complentary points value added to his tally at a
different value to an actual win) or any other letter for that matter are
added into the record card, the result cell still shows a win value as though
the game was played and legitimately won. In the event of a default win, I
have another column which is picking those values out, thus I am duplicating
wins. So how do I seperate or filter the values so that letters are ignored
in my actual win cell and avoid this duplication. I have tried IS functions
but I'm new to them and don't have a good understanding of them yet. Urgent
help on this will be appreciated by me and a lot of players. - Thanks for
your time.