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.

Thankfully, I managed to get an answer from another source which read:-

I am not sure I understand what you are looking for, do you mean to test if
I4 is a number then do the logic test with B2? If so

=IF(AND(ISNUMBER(I4),I4($B$2/2)),1,0)

will return 0 for DW in I4

Regards,

Peo Sjoblom

Thanks Peo - It was exactly what I was looking for.



"Big Trev" wrote:

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.