Microsoft Excel Formula Result From 3 Cards

Hi,

Pretty simple task but I just dont have the time to do it.

If I keyed into a spreadsheet the result of three playing cards laid out in front of me (eg: Jack of hearts, Jack of diamonds, three of clubs) I would key in JH JD 3C into three cells next to eachother

I need a formula that will tell me if the result is a Royal Flush, Flush, straight, straight flush, one pair, three of a kind etc…. I can provide all of the possible results

The result will a one word answer in the format “straightflush” or “threeofakind”

Prefer if the formula is in excel but open to suggestions

Leave a Reply

Your email address will not be published. Required fields are marked *