Formula always returns the false response

[honkin]

Any idea why this formula always returns the false, even if the result is true?

=IF(AND(K2>="2",N2="Under 1.5"),"W","L")

Predictology_Trading Template v3.1.xlsm
	J	K	L	M	N
1	FT A	FT Total	Result	Matches	Bet Type
2	0	1	L	1	Under 1.5
3	1	3	L	2	Under 1.5
4	1	3	L	3	Under 1.5
5	2	4	L	4	Under 1.5
6	3	5	L	5	Under 1.5
7	1	2	L	7	Under 1.5
8	0	2	L	8	Under 1.5
9	2	3	L	9	Under 1.5
Maria Lay

Cell Formulas
Range	Formula
J2:J9	J2	=IFERROR(INDEX('Predictology Result File'!$J$2:$J$14608,MATCH(1,INDEX((A2='Predictology Result File'!$A$2:$A$14608)*(B2='Predictology Result File'!$B$2:$B$14608)*(C2='Predictology Result File'!$C$2:$C$14608),0,1),0)),"No")
K2:K9	K2	=IFERROR(INDEX('Predictology Result File'!$K$2:$K$14608,MATCH(1,INDEX((A2='Predictology Result File'!$A$2:$A$14608)*(B2='Predictology Result File'!$B$2:$B$14608)*(C2='Predictology Result File'!$C$2:$C$14608),0,1),0)),"No")
L2:L9	L2	=IF(AND(K2>="2",N2="Under 1.5"),"W","L")
N2:N9	N2	=IF(C2<>"","Under 1.5","")
M3:M9	M3	=IF(D3<>"",M2+1,"")

You can see that all bar the first row in K are >=2 and N is Under 1.5 in all of them, yet all the results come back as L

Any thoughts on what I have done wrong here?

cheers

 

[Peter_SSs]

2 is a number but "2" is text so remove the quotes from the 2

=IF(AND(K2>=2,N2="Under 1.5"),"W","L")

 

[Toadstool]

Hi Honkin,

Column K looks numeric so try

=IF(AND(K2>=2,N2="Under 1.5"),"W","L")

 

[honkin]

2 is a number but "2" is text so remove the quotes from the 2

=IF(AND(K2>=2,N2="Under 1.5"),"W","L")

cheers Peter but it still returns L all down that column.

Both column N and K are generated dynamically from other data, but that shouldn't matter, should it? I mean, the result in K and N should be all that matters, or could that be causing an issue?

cheers

 

[honkin]

cheers Peter but it still returns L all down that column.

Both column N and K are generated dynamically from other data, but that shouldn't matter, should it? I mean, the result in K and N should be all that matters, or could that be causing an issue?

cheers

I just tried something to check if it made a difference, I typed 2 into K2 and typed Under 1.5 into N2, so no dynamic data there, but the response is still L

I'm kinda stuck

cheers

 

[Peter_SSs]

I don't have your other worksheet to generate exactly what you have but with the values entered manually, it works for me.

21 11 10.xlsm
	J	K	L	M	N
1	FT A	FT Total	Result	Matches	Bet Type
2	0	1	L	1	Under 1.5
3	1	3	W	2	Under 1.5
4	1	3	W	3	Under 1.5
5	2	4	W	4	Under 1.5
6	3	5	W	5	Under 1.5
7	1	2	W	7	Under 1.5
8	0	2	W	8	Under 1.5
9	2	3	W	9	Under 1.5
Sheet2 (2)

Cell Formulas
Range	Formula
L2:L9	L2	=IF(AND(K2>=2,N2="Under 1.5"),"W","L")

Also check that you calculation is set to Automatic: File -> Options -> Formulas

 

[honkin]

I don't have your other worksheet to generate exactly what you have but with the values entered manually, it works for me.

21 11 10.xlsm
	J	K	L	M	N
1	FT A	FT Total	Result	Matches	Bet Type
2	0	1	L	1	Under 1.5
3	1	3	W	2	Under 1.5
4	1	3	W	3	Under 1.5
5	2	4	W	4	Under 1.5
6	3	5	W	5	Under 1.5
7	1	2	W	7	Under 1.5
8	0	2	W	8	Under 1.5
9	2	3	W	9	Under 1.5
Sheet2 (2)

Cell Formulas
Range	Formula
L2:L9	L2	=IF(AND(K2>=2,N2="Under 1.5"),"W","L")

Also check that you calculation is set to Automatic: File -> Options -> Formulas

View attachment 50856

ah what a twit I was, Peter. I have an ongoing battle with the automatic setting, often disabling it when adding lots of results, as it slows things down. Flicked it back and fine

Thanks so much for your help and sorry for that rookie error

cheers

 

[Peter_SSs]

No problem. Glad to help.