Forum Discussion
Formula for playing cards
- correct the prior Column E should have been deleted
so basically 4 cards to an inside straight possibilities. I will see if I can come up with something but it will cost you. jk. but a few likes wouldn't hurt. lol.
My goal is to make rename the FALSE and TRUE names in this list. I am not the only one to use this worksheet so I need to clarify things for them. In the formula you included "4 connected" for example. I really like that you included this. And I know that I can rename this. But TRUE/FALSE is not in-between quotation marks. So I don't know how the rename that. ''3 connected'' is easier to understand than ''TRUE''.
https://gyazo.com/4a92e07ce7c787ddce6c6778bf75d5f1
Can I just add the paired column to formula in the ''Straight'' column as well?
=IFERROR(IF(FIND(LEFT(B4,1),A4),"Exist","Not Exist"),"Not Exist")
I tried to add it between these lines of your formula. But it didn't work.
= IF((A4="")+(B4=""),"",
IF(("Check for 4-card straight"="")+
My goal is to have everything under 1 column. It looks cleaner and people can just choose in the list what they want to filter for.
So that the list would become like this:
- Paired
- 4 Connected
- 3 Connected
- Gutshot
- Nothing
Kalthof Updated accordingly. I left the "paired" column in just for you to compare if you like but it isn't needed now. Are you sure you want "FALSE" shown for the rest? maybe "n/c" instead? What about pairs or 3 connected on flop? Should those have anything like "n/c - pair" and "n/c - 3 connected"?
- Haha I would if I not already had that. The suits follow a logical pattern in my document. So I was able to solve that issue without a formula. But thank you anyway.
https://gyazo.com/f1f4184de71d77cc5f65f4ab2b8113e8 - You are the absolute best. I already feel like overreaching but you just go over the top be adding another thing.
A thousand thanks! Kalthof "n/c" is commonly used for "no change" but I replaced false with "-" in the attached and added the 3 of a kind, 4 of a kind, and 2 pair also 🙂
it was kind of neat how it worked out. I found out how many times the new card # was in the flop and then:
if 0 do everything as before
if 1 then found a "pair"
if 2 then found 3 of kind
if 3 then 4 of a kind
then I went back to the pair and checked if 2 of the cards had a pair in the flop and if so then 2 of a kind otherwise just a pair.
Do you mean ''not connected'' by n/c? I would rather have FALSE replaced by ''Nothing'' or ''None''. Or at least something so I can rename it later in time.
For the flop It is not necessary to have something. Thank you.
What would be great though. Is add a ''Three of a kind'' (and ''Double paired'') filter option. On 554+5 for example (554+4). But you have already done so much. So don't feel obligated whatsoever.