Nesting Multiple Large IFAND Statements

[Snake Eyes]

Greetings.
I can't seem to get these 3 nested IFAND statements into one large formula where if they are all False I can leave the cell blank or if any are true they show their respective value.

=IF(AND(I33<=0.05),IF(AND(P33>=0.301,P33<=0.501),IF(AND(Z33>=0,Z33<=15),IF(AND(Q33>=-0.1,Q33<=0.06),IF(AND(J33<0.25),"Recommend",IF(AND(I38>=0,I38<=0.255),IF(AND(P38>=0.301,P38<=0.8),IF(AND(Z38>=0,Z38<=30),IF(AND(Q38>=-0.1,Q38<=0.06),IF(AND(J38>=-10,J38<=0.2549),"Consider",IF(AND(I38>=0.256,I38<=0.5),IF(AND(P38>=0.5,P38<=0.8),IF(AND(Z38>=30,Z38<=90),IF(AND(Q38>=-0.1,Q38<=0.06),IF(AND(J38>=0,J38<=0.75),"Monitor","")))))))))))))))

 

[DanteAmor]

In the first part of the formula you are evaluating the cells in row 33:

IF(AND(I33<=0.05),IF(AND(P33>=0.301,P33<=0.501),IF(AND(Z33>=0,Z33<=15),IF(AND(Q33>=-0.1,Q33<=0.06),IF(AND(J33<0.25),"Recommend"

But in the next part of the formula you evaluate row 38, is that correct?

IF(AND(I38>=0,I38<=0.255),IF(AND(P38>=0.301,P38<=0.8),IF(AND(Z38>=0,Z38<=30),IF(AND(Q38>=-0.1,Q38<=0.06),IF(AND(J38>=-10,J38<=0.2549),"Consider" ...

 

[Snake Eyes]

Hi DanteArmor,
Good catch. The answer is no, that is not correct. All references should be for the same row.
I can make the adjustment once I get my original question answered.

 

[DanteAmor]

Could you check the ranges? Some seem to have sequence and others do not make sense.
There are matches that could be in "Recommend" and also in "Consider", but since the first condition is met, then they will never appear as "Consider".

Check your ranks in the following table:

varios 09nov2022.xlsm
	A	B	C	D
7	Recommend	I		<=0.05
8		P	>=0.301	<=0.501
9		Z	>=0	<=15
10		Q	>=-0.1	<=0.06
11		J		<=0.25
12
13	Consider	I	>=0	<=0.255
14		P	>=0.301	<=0.8
15		Z	>=0	<=30
16		Q	>=-0.1	<=0.06
17		J	>=-10	<=0.2549
18
19	Monitor	I	>=0.256	<=0.5
20		P	>=0.5	<=0.8
21		Z	>=30	<=90
22		Q	>=-0.1	<=0.06
23		J	>=0	<=0.75
Hoja4

Or if you already have a table with values, it would be more practical to review it in a table than in a formula.

 

[Snake Eyes]

True,
Some of the ranges include values that fall within other groups. That’s done intentionally.

The 3 groups should be designed to return the True value only if ALL the conditions within the group are met.

 

[DanteAmor]

Try:

Dante Amor
	E				I	J						P	Q									Z
33	Monitor				0.26	0.24						0.6	0.02									31
34	Recommend				0.04	0.24						0.302	0.02									1
35	Consider				0.24	0.24						0.302	0.02									1
36	None				0.26	0.24						0.6	0.02									1
Hoja4

Cell Formulas
Range	Formula
E33:E36	E33	=IF(AND(I33<=0.05,P33>=0.301,P33<=0.501,Z33>=0,Z33<=15,Q33>=-0.1,Q33<=0.06,J33<=0.25),"Recommend", IF(AND(I33>=0,I33<=0.255,P33>=0.301,P33<=0.8,Z33>=0,Z33<=30,Q33>=-0.1,Q33<=0.06,J33>=-10,J33<=0.2549),"Consider", IF(AND(I33>=0.256,I33<=0.5,P33>=0.5,P33<=0.8,Z33>=30,Z33<=90,Q33>=-0.1,Q33<=0.06,J33>=0,J33<=0.75),"Monitor","None")))