Formula Help - High to Low and Odd to Even

[ststern45]

Hello everyone,

I have 2 requests but they refer to the same cell range

Cell range = A1 through C1

Example: Each cell can have a value from 0 through 9

A1 = 0
B1 = 0
C1 = 0

Even to Even formula
A1 = 0 (even)
B1 = 0 (even)
C1 = 0 (even)

So the result would be 2 (even follows an even (B1 from A1) & even follows an even C1 follows B1)

Also need formulas for the following

Even to Odd
Odd to Even
Odd to Odd

Low to High (Low digits = 0,1,2,3,4 High digits = 5,6,7,8,9)
Low to Low
High to Low
High to High

Thank you in advance!!

 

[shg]

	A​	B​	C​	D​	E​	F​	G​	H​	I​
1​	num1​	num2​	num3​	E-E​	O-O​	E-O​	L-H​	​	​
2​	0​	2​	9​	1​	0​	1​	1​		D2: =SUMPRODUCT((MOD($A2:$B2, 2) = MOD($B2:$C2, 2)) * (MOD($A2:$B2, 2) = 0))
3​	1​	7​	0​	0​	1​	0​	1​		E2: =SUMPRODUCT((MOD($A2:$B2, 2) = MOD($B2:$C2, 2)) * (MOD($A2:$B2, 2) = 1))
4​	2​	6​	4​	2​	0​	0​	1​		F2: =SUMPRODUCT((MOD($A2:$B2, 2) <> MOD($B2:$C2, 2)) * (MOD($A2:$B2, 2) = 0))
5​	1​	4​	5​	0​	0​	1​	1​		G2: =SUMPRODUCT(($A2:$B2 < 5) * ($B2:$C2 >= 5))
6​	9​	3​	7​	0​	2​	0​	1​
7​	6​	0​	1​	1​	0​	1​	0​
8​	3​	1​	3​	0​	2​	0​	0​
9​	0​	6​	9​	1​	0​	1​	1​
10​	2​	2​	4​	2​	0​	0​	0​
11​	6​	4​	9​	1​	0​	1​	1​
12​	4​	9​	0​	0​	0​	1​	1​
13​	8​	9​	0​	0​	0​	1​	0​
14​	0​	2​	0​	2​	0​	0​	0​
15​	4​	4​	6​	2​	0​	0​	1​
16​	5​	4​	9​	0​	0​	1​	1​
17​	0​	1​	7​	0​	1​	1​	1​
18​	0​	8​	9​	1​	0​	1​	1​
19​	0​	8​	3​	1​	0​	1​	1​
20​	3​	1​	5​	0​	2​	0​	1​
21​	2​	6​	5​	1​	0​	1​	1​

I'll let you play with the others.