Odd's & Evens

[bloubul]

Hi PAB,

I need some help with this formula, can you provide me with a better one please: "=IF(C2*0.5=INT(C2*0.5),1,0)+IF(D2*0.5=INT(D2*0.5),1,0)+IF(E2*0.5=INT(E2*0.5),1,0)+IF(F2*0.5=INT(F2*0.5),1,0)+IF(G2*0.5=INT(G2*0.5),1,0)+IF(H2*0.5=INT(H2*0.5),1,0)" +"=$L$1-J2" I use this to determin odd and even numbers per draw. This is the results up to date.

Nr of Draws = 501
Even 6 5 4 3 2 1 0
Odd 0 1 2 3 4 5 6
Result 7 44 120 175 118 34 3
Percentage 1.4 8.8 24.0 34.9 23.6 6.8 0.6

Can you also help me with a VB script that can sort a wheel 10,000 lines in the same manner please.


Thanking you in advance

BlouBul

 

[PAB]

Hi BlouBul,

You have NOT said what Figures are in Cells "L1" OR "J2" ( shown in your Formula as +"=$L$1-J2", which will NOT Work by the Way ).

I need some help with this formula, can you provide me with a better one please: "=IF(C2*0.5=INT(C2*0.5),1,0)+IF(D2*0.5=INT(D2*0.5),1,0)+IF(E2*0.5=INT(E2*0.5),1,0)+IF(F2*0.5=INT(F2*0.5),1,0)+IF(G2*0.5=INT(G2*0.5),1,0)+IF(H2*0.5=INT(H2*0.5),1,0)" +"=$L$1-J2" I use this to determine odd and even numbers per draw.

Place the Following Formula in Cell "J2" to Obtain the Total Number of ODDS in a Draw :-
=IF(C2=0,"",SUMPRODUCT(--(MOD(C2:H2,2)=1),--ISNUMBER(C2:H2)))
Place the Following Formula in Cell "K2" to Obtain the Total Number of EVENS in a Draw :-
=IF(C2=0,"",SUMPRODUCT(--(MOD(C2:H2,2)=0),--ISNUMBER(C2:H2)))

Adjust the Cell References Accordingly.
Then just Copy these Two Formulas Down Past your Current Data by about 50 Rows to Allow for Future Data.
I have Included an Error Check in BOTH Formulas ( Targeted at the First Cell of Entry of a Draw, this is in Case the Cell is Blank OR Zero ) for Draws that have NO Figures in Yet.

Hope this Helps.
All the Best.
PAB

 

[bloubul]

Hi PAB

Thanks PAL you remain a "STAR" of this forum.

In cell J2 was that long formula I posted and in $L$1 was the figure 6, and then pasted in K2 (K2 will read =$L$1) and then copied down wards as well as J2. The "+" was an error of the fingers, sorry.

The new formulas works great.
Thanks again.

BlouBul