Odd Even formula

[serge]

I need a formula that will return 1 if the criteria is : Even,Odd,Even,Odd,Even,Odd,Even.
If not a blank cell.

Example :

A1:G1 2-5-8-5-6-3-0
H1 will return 1 or Blank.

Thank you.

 

[serge]

Yes, you did pushkardey,

Your formula also works great, you guys are really awesome.

Thank you very for all the help.
Serge.

 

[pushkardey]

Yes, you did pushkardey,

Your formula also works great, you guys are really awesome.

Thank you very for all the help.
Serge.

Glad to be of assistance...

 

[Marcelo Branco]

Thank you Marcelo for giving me both solution.

But I choose your 1st one and it work fine, I'm trying not to put macro in my file, I'm able to play around with the formulas.

Thank you for the precious help.
Serge.

You are welcome and tks for the feedback.

M.

 

[snoopyhr]

Hi Serge,

Curious.... can you explain what is the application of this ? is it a sort of control? or exception reporting ? I am just curious. thanks,

 

[serge]

Pushkardey and Marcelo Branco,

I used your formulas,
=IF((MOD(A1+C1+E1+G1,2)&MOD(B1+D1+F1,2))="01",1,"")
=IF(AND(MOD(A1+C1+E1+G1,2)=0,MOD(B1+D1+F1,2)=1),1,"")

and they worked with my test file but when I enter them in my real file they wouldn't give me the right result ??? why is that ?
My actual cells range are : AG6:AM6 up to row 600.

Sorry about the late reply,I had to leave and I just got back !!

The only formula that worked perfectly is the 2nd one in Mikerickson's post.

I change a bit the range of his formula to adapt to mine and scroll down to all my data and the result is perfect.

I need to change the formula to work for different criteria for example :

1) OEOEOEO
2) EEEEEEE
3) OOOOOOO
4) EEEOOOO
Etc..

I tried to fix it but I couldn't figure it out how, can someone explain what need to be change in the formula to make it happen for the example above ? and then I'll be able to do the other one.

Thanks for the help.
Serge.

 

[serge]

Hi snoopyhr,

It's for some game data that I try to see which have most of Odd or Even numbers and in which position.

 

[Armando Montes]

Try this:
=IF(MOD(A1,2)=0,"E","O")&IF(MOD(B1,2)=0,"E","O")&IF(MOD(C1,2)=0,"E","O")...

 

[serge]

Thanks Armando for the formula, I'm good with that one.

What I'm asking is how to change the formula from Mikerickson ( post # 2 )

=IF(6=SUMPRODUCT(MOD(COLUMN(A1:F1)+A1:F1, 2)), 1, "")

( Because I haven't heard from him after that !! ).

This one work for EOEOEOE.
I need to change it for OEOEOEO ( IN THAT ORDER )
and then for EEEOOOO, and OOOOEEE, Etc...Etc...,

What I would like is to understand how the formula works, this way I wouldn't bother anyone and would be able to change it as needed for my file.

I hope someone can brake it down for me.

Thank you.
Serge.

 

[Armando Montes]

This formula =IF(6=SUMPRODUCT(MOD(COLUMN(A1:F1)+A1:F1, 2)), 1, "")
evaluates the whole range, not single columns.