# Formula Help - High to Low and Odd to Even

#### ststern45

##### Well-known Member
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

### Excel Facts

Bring active cell back into view
Start at A1 and select to A9999 while writing a formula, you can't see A1 anymore. Press Ctrl+Backspace to bring active cell into view.

#### shg

##### MrExcel MVP
 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.

Replies
1
Views
58
Replies
6
Views
165
Replies
3
Views
357
Replies
1
Views
631
Replies
4
Views
290

1,129,915
Messages
5,638,970
Members
417,062
Latest member
Canucks21

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back