IF cell equals cell range question

[Butcher1]

Roullete betting strategy sample.xlsx

I am having a lot of trouble finding the answer to my problem. What I want to do in simple terms is say "if the number in this specific cell is found in this array of cells, return this text, if not then return this other text".

In more complicated and thorough terms I want to say if Spins G3 cell number is found in Bets M1:N19 (or M1:M38 if it makes it easier), display the text WIN, if not then return the text LOSE.

While I would appreciate an formula that works, I would really appreciate an explanation of how it works, as I have searched multiple options and tried them and end up with value or na or other errors that prevent the formula from working correctly. Thank you.

[RobertMika]

Is this to be found on Spins or bets.
You have two formulas(3 actually) pointing to different sheets,Besides Bets M1:n19 are empty.

[benishiryo]

hi there. you can't have more than 1 separate formulas in a single cell like in G3:
=IF(Bets!M1:Bets!N19=G2, "Win", "Lose")
=IF(Spins!M1:N19=Spins!G2,"WIN","LOSE")
=IF(COUNTIF(B1:B29, 4) >0, "YES", "NO")

i'm taking the 1st one since that's what you described. 2nd thing. i suppose your quote below means Spins G2?

if Spins G3 cell number is found in Bets M1:N19

G3 is the cell with the formula.

3rd thing. if you compare a single cell with another single cell, you get a single result right? for eg.
=IF(Bets!M1=G2, "Win", "Lose")
but if you compare a range with a single cell, you are going to get multiple results that compares Bets!M1 with G2, Bets!M2 with G2, Bets!M3 with G2, and so on...
Excel won't know which result do you want. so use COUNTIF instead
=IF(COUNTIF(Bets!$M$2:$N$19,G2)>0,"Win","Lose")

COUNTIF will count how many times G2 appeared in M2:N19. so if that number is more than 0, label as "Win". otherwise, "Lose".

[Butcher1]

The formula is on Spins, specifically Spins G3. M1:N19 is blank because I cleared it prior to saving and uploading just to ensure I didn't have anything in those cells that would throw off the formula.

[Butcher1]

Excel won't know which result do you want. so use COUNTIF instead
=IF(COUNTIF(Bets!$M$2:$N$19,G2)>0,"Win","Lose")

COUNTIF will count how many times G2 appeared in M2:N19. so if that number is more than 0, label as "Win". otherwise, "Lose".

I tried a IF formula which nested a COUNT formula and it didn't work, however this formula does work. Thank you. I will analyze your full answer later on. Thanks.