Formula with if and odd rows

[jevi]

Hi All,

I am trying to make a formula but no result. The if that i need IF is like in the fourth column.

The first row is OK because the cell B2 is empty and C2 has the same value as C1. So the secondo row is considered also OK.
The third row is Ok because B4 is empty and C4 has the same value as C3. So the row 4 is considered also OK.
The fifth row is Alert because B6 is not empty and C6 is different from C5.
The sixth row is Alert because is the last row where there is no more data after it or let say because C7 is different from C6.

Any help with this formula? The logic is that after each code in column B it should be a row with empty code but the the same sum in column C as the one above, that is OK otherwise Alert.

Thank you,

 

[Automatrix]

Could probably be shorter, but gets the job done.

Book1
	A	B	C	D
1		Code	Sum	IF
2	1	00456	9100	OK
3	2		9100	OK
4	3	0057	8200	OK
5	4		8200	OK
6	5	0058	8300	alert
7	6	00601	8400	alert
8	7
Sheet4

Cell Formulas
Range	Formula
D2:D7	D2	=IF(ISODD(A2),IF(AND(B3="",C2=C3),"OK","alert"),IF(AND(B2="",C2=C1),"OK","alert"))

 

[Mortiray]

You don't need to check if the row is odd. Use the following formula:

=IF(OR(AND(B2="", NOT(B3=""), C2=C1), AND(NOT(B2=""), B3="", C2=C3), "OK", "ALERT")

The logic breaks down as follows

If either of the following are true (these are the two success cases)
--This B value is blank, the next B value is not blank, and this C value is equal to the previous C value
--This B value is not blank, the next B value is blank, and this C value is equal to the next C value
then the data line is OK. Otherwise, return an Alert

Omitting the odd row checking makes this formula portable to any location on any sheet as long as your table is formatted the same way

 

[jevi]

@ Automatrix, It didn't work n my file but maybe we don't need to go with ODD, my fault as thinking that after the code the odd should be empty. Still thank you for your formula.

@ Mortiray it worked great and true no need for ODD but I did the confusion. Most of all thank you for the explanation as I did understand better the formula.

thank you a lot