How do I sort differeing types of data into different numerica va
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. |
How do I sort differeing types of data into different numerica va
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. |
All times are GMT +1. The time now is 06:20 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com