Odd Even formula help

Reply #12

frenchie — Sat, 04 Jun 2011 18:58:35 GMT

Hi CARBOB,

Sorry to take so long to respond, I tried your formula but I guess it won't work without the Morefunc add-in, and I don't know how to work it, so I find this formula that works fine for me :

=CONCATENATE(IF(MOD(A1,2)=0, E , O ),IF(MOD(B1,2)=0, E , O ),IF(MOD(C1,2)=0, E , O ),IF(MOD(D1,2)=0, E , O ),IF(MOD(E1,2)=0, E , O ),IF(MOD(F1,2)=0, E , O ),IF(MOD(G1,2)=0, E , O ))

But I want to thank you for the help.

Reply #11

CARBOB — Wed, 25 May 2011 17:07:56 GMT

Serge,

Is this what you're looking for?

2985630 EOEOEOE

You will need the Morefunc add-in on your computer. Enter the Array formula with the Ctrl-Shift-Enter

=MCONCAT(IF(MOD((MID($AH11,{1,2,3,4,5,6,7},1)+0),2)=0, E , O

Reply #10

KnuckleHead — Wed, 25 May 2011 16:54:54 GMT

Morning frenchie,

Sorry to read that the formula didn't work.

After thinking on your problem for a few days now, what I think you'll need is not a formula but a custom function that contains each of your E-O-E-O-E-O-E patterns and can place a number in the cell to designate the pattern number for you.

This way whatever E-O-E-O-E-O-E pattern comes up in a draw, you'll know it right away and then you could add up how many times that pattern apperas in the draw history. I've created this t... [ More ]

Reply #9

JosephusMinimus — Tue, 24 May 2011 12:34:09 GMT

Nice post KH. Thanks.

Reply #8

frenchie — Tue, 24 May 2011 06:09:27 GMT

KnuckleHead,

I really do appreciate your help, and I gave it a try with no success.

I don't think Excel recognizes this kind of formula, It looks different than others.

But I'm no one to judge since I don't know how to build them.

obviously no one can help, so I'm will stop for this tread.

Thank you.

Serge.

Reply #7

KnuckleHead — Mon, 23 May 2011 18:30:03 GMT

frenchie,

Let's try this again...

I created the formula below using Quattro Pro 12 running in Excel mode. The program keep putting the Array around the formula each time I tested it until I got it built. It did work for what you were asking about. For future number patterns, you can modify each of the ISEVEN and ISODD to get the result that your looking for. The =1 in each formula section means that the formula is True .

@ARRAY(@IF(@ISEVEN(A1)=1#AND#@ISODD(B1)=1#AND#@ISEVEN(C1)=1#AND#@I... [ More ]

Reply #6

KnuckleHead — Mon, 23 May 2011 16:29:27 GMT

Morning Frenchie,

I see wait it is your looking for now. I misunderstood before. Since I work in Lotus, Momma has a computer that has Excel on it. Let me see if I can put a formula together for you. I would think that one of the other members that use Excel could do it quicker though.

I'll get back to you.

Sorry for the misunderstanding,

KnuckleHead

Reply #5

frenchie — Mon, 23 May 2011 08:30:31 GMT

You can also use this one :

=CONCATENATE(IF(MOD(A1,2)=0, E , O ),IF(MOD(B1,2)=0, E , O ),IF(MOD(C1,2)=0, E , O ))

have your 3 digits in A1:C1.

But this is not, what I was asking for, what I want is a formula for each set of E-O of 7 digits.

The formula would return a ( 1 ) or a ( BLANK CELL ) when the digits math the criteria.

If the formula is set to find EOEOEOE, then it will return a ( 1 ) if not a ( Blank cell ).

And this for every different set of E-O that I would set up,

Reply #4

frenchie — Mon, 23 May 2011 04:11:47 GMT

Thanks for the reply but I don't know how to write those formula that's why I ask for help.

Reply #3

KnuckleHead — Mon, 23 May 2011 02:56:37 GMT

Hello frenchie,

I use Lotus 123. The below formula works in a Pick 3 file.

B25 = 9

C25 = 9

D25 = 4

@IF(B25=@ODD(B25), O , E ) @IF(C25=@ODD(C25), O , E ) @IF(D25=@ODD(D25), O , E )

and it results in O O E

If your using Excel, look at =ISEVEN (Returns TRUE if number is even, or FALSE if number is odd).

and =ISODD (Returns TRUE if number is odd, or FALSE if number is even). You can write a =IF formula using one of these

functions. You should be able to string them togeth... [ More ]

Reply #2

frenchie — Mon, 23 May 2011 02:34:37 GMT

Excel 2007

Reply #1

GASMETERGUY — Mon, 23 May 2011 00:48:48 GMT

Is this for an Excel program? If not, then what kind of programming language do you have

Odd Even formula help

frenchie — Sun, 22 May 2011 23:50:14 GMT

Hi everyone,

I need a formula that will return 1 if the criteria is : E,O,E,O,E,O,E ( in that order ), If not a blank cell.

Example :

A1:G1 2-9-8-5-6-3-0

E-O-E-O-E-O-E H1, will return 1 if the digits are in that order if not a Blank cell.

Could you explain what need to be change in the formula to adapt it to a diferent order with the E,O as needed, please.

Example :

If I want E,E,E,O,O,O,O which formula ?

OR O,E,O,E,O,E,O which formula ?

OR O,E,O,E,E,E,O which