IF CONDITIONAL FORMATTING

[Samgraphics]

HI, CAN YOU PLEASE HELP ME?
I'M TRYING TO CREATE AN IF CONDITIONAL FORMATTING FOR THIS

WHAT I'M TRYING TO DO IS THIS, SEE SCREENGRAB. I'M TRYING TO GROUP COMBINATIONS OF NUMBERS INTO HIGH/LOW ODD/EVEN SETS
NUMBERS THAT ARE LOWER THAN 10 ARE "LOW LOW + ODD/EVEN"
GREATER THAN 10 BUT LESS THAN 18 ARE "HIGH LOW + ODD/EVEN"
GREATER THAN 18 BUT LESS THAN 27 ARE "LOW HIGH + ODD/EVEN"
AND GREATER THAN 27 ARE "HIGH HIGH + ODD/EVEN"
I'VE COME UP WITH THESE TWO OPTIONS. THE FIRST ONE IS ONLY GIVING ME HALF OF WHAT I WANT. IT GETS THE "LOW LOW" AND THE "HIGH LOW"
=IF(C2>$AF$3,"HIGH","LOW")&" "&IF(C2>$AF$2,"HIGH","LOW")&" " & IF(ISODD(C2),"ODD","EVEN")

THIS ONE IS GETTING ME 3/4 OF THE WAY
=IF(AND(C2>$AF$3,C2>$AF$2,C2>$AF$4),"HIGH","LOW")&" "&IF(OR(AND(C2>$AF$3),(C2>$AF$2),(C2>$AF$4)),"HIGH","LOW")&" " & IF(ISODD(C2),"ODD","EVEN")

I ALSO TRIED THIS BUT IT'S ONLY GETTING ME 3 OF THE CORRECT RESULTS
=IF(OR(C2<$AF$2,C2<$AF$3,C2<$AF$4),"LOW","HIGH")&" "&IF(OR(C2>$AF$2,C2>$AF$3,C2>$AF$4),"HIGH","LOW")&" " & IF(ISODD(C2),"ODD","EVEN")

BUT I'M COMPLETELY LOST AFTER THAT


PLEASE HELP ME.
THANK YOU SO MUCH

 

[Saurabhj]

Hi,

Please check below:

Book1
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S	T	U	V	W	X	Y	Z	AA	AB	AC	AD	AE	AF	AG
1
2			5	LOW LOW ODD																												18
3			4	LOW LOW EVEN																												10
4			14	HIGH LOW EVEN																												27
5			15	HIGH LOW ODD
6			20	LOW HIGH EVEN
7			21	LOW HIGH ODD
8			30	HIGH HIGH EVEN
9			31	HIGH HIGH ODD
10
11
12
13
14
15
16
17
18
19
Sheet1

Cell Formulas
Range	Formula
D2:D9	D2	=IF(C2>$AF$4,"HIGH HIGH",IF(C2>$AF$2,"LOW HIGH",IF(C2>$AF$3,"HIGH LOW","LOW LOW"))) & IF(ISODD(C2)," ODD"," EVEN")

 

[Saurabhj]

Another way:

If Condition.xlsx
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S	T	U	V	W	X	Y	Z	AA	AB	AC	AD	AE	AF
1
2			5	LOW LOW ODD	LOW LOW ODD																											18
3			4	LOW LOW EVEN	LOW LOW EVEN																											10
4			14	HIGH LOW EVEN	HIGH LOW EVEN																											27
5			15	HIGH LOW ODD	HIGH LOW ODD
6			20	LOW HIGH EVEN	LOW HIGH EVEN
7			21	LOW HIGH ODD	LOW HIGH ODD
8			30	HIGH HIGH EVEN	HIGH HIGH EVEN
9			31	HIGH HIGH ODD	HIGH HIGH ODD
10
11
Sheet1

Cell Formulas
Range	Formula
D2:D9	D2	=IF(C2>$AF$4,"HIGH HIGH",IF(C2>$AF$2,"LOW HIGH",IF(C2>$AF$3,"HIGH LOW","LOW LOW"))) & IF(ISODD(C2)," ODD"," EVEN")
E2:E9	E2	=IF(AND(C2>$AF$4,ISODD(C2)),"HIGH HIGH ODD",IF(AND(C2>$AF$2,ISODD(C2)),"LOW HIGH ODD",IF(AND(C2>$AF$3,ISODD(C2)),"HIGH LOW ODD",IF(AND(C2>$AF$4,ISEVEN(C2)),"HIGH HIGH EVEN",IF(AND(C2>$AF$2,ISEVEN(C2)),"LOW HIGH EVEN",IF(AND(C2>$AF$3,ISEVEN(C2)),"HIGH LOW EVEN",IF(AND(C2<$AF$2,ISEVEN(C2)),"LOW LOW EVEN","LOW LOW ODD")))))))

 

[Saurabhj]

Hi, sorry for multiple post.

Although the above two methods will show the correct output. If you are using Excel 2019 or Excel 365, you can use below If statement:

=IFS(AND(C2>$AF$4,ISODD(C2)),"HIGH HIGH ODD",AND(C2>$AF$2,ISODD(C2)),"LOW HIGH ODD",AND(C2>$AF$3,ISODD(C2)),"HIGH LOW ODD",AND(C2>$AF$4,ISEVEN(C2)),"HIGH HIGH EVEN",AND(C2>$AF$2,ISEVEN(C2)),"LOW HIGH EVEN",AND(C2>$AF$3,ISEVEN(C2)),"HIGH LOW EVEN",AND(C2<$AF$2,ISEVEN(C2)),"LOW LOW EVEN",AND(C2<$AF$2,ISODD(C2)),"LOW LOW ODD")

 

[Samgraphics]

Hi, sorry for multiple post.

Although the above two methods will show the correct output. If you are using Excel 2019 or Excel 365, you can use below If statement:

=IFS(AND(C2>$AF$4,ISODD(C2)),"HIGH HIGH ODD",AND(C2>$AF$2,ISODD(C2)),"LOW HIGH ODD",AND(C2>$AF$3,ISODD(C2)),"HIGH LOW ODD",AND(C2>$AF$4,ISEVEN(C2)),"HIGH HIGH EVEN",AND(C2>$AF$2,ISEVEN(C2)),"LOW HIGH EVEN",AND(C2>$AF$3,ISEVEN(C2)),"HIGH LOW EVEN",AND(C2<$AF$2,ISEVEN(C2)),"LOW LOW EVEN",AND(C2<$AF$2,ISODD(C2)),"LOW LOW ODD")

HI not at all, thank you so much for the quick reply and the solutions. They all work perfectly, well except for the last one because I'm on excel 2011, but the other's are working great.

I'm such an idiot, it never occurred to me to just put the two words together like you did, instead I'm trying to concatenate them in the formula. man I'm dumb. ?
Again thank you very much for your time and your help.