Discussion about math, puzzles, games and fun.   Useful symbols: ÷ × ½ √ ∞ ≠ ≤ ≥ ≈ ⇒ ± ∈ Δ θ ∴ ∑ ∫ • π ƒ -¹ ² ³ °

You are not logged in.

## #26 2013-04-28 04:00:17

JoshH
Member

Offline

### Re: Greetings!

Unfortunately it will not let me post links to the screen cap of it.

## #27 2013-04-28 04:07:44

bob bundy
Moderator

Online

### Re: Greetings!

There's a time delay before new members can post images.  Bit of a nuisance, but it's needed to make abuse etc less frequent.

If you have somewhere you can post an image you can tell me the address here.

Do it like this

htt etc

ww etc

I'll re-build it and post it properly, which may help some other soul who is trying to follow this thread.

Bob

You cannot teach a man anything;  you can only help him find it within himself..........Galileo Galilei

## #28 2013-04-28 04:08:49

JoshH
Member

Offline

### Re: Greetings!

/albums/cc214/Hayabusakota/ScreenShot2013-04-27at15702PM.png

JoshH
Member

Offline

## #30 2013-04-28 04:33:57

bob bundy
Moderator

Online

### Re: Greetings!

hi

Just been looking at the formulas.  Let's see if I've got it.

B2 contains the zero/one number from ten rolls.  eg. 1010111101

B3 initially contains zero.

FIND(1111,B2) looks to see if 1111 occurs and if it does B3 is incremented by 1

If it doesn't then IFERROR traps the value error and puts B3 back in B3, so B3 is not incremented.

So what happens if you put 1010111101 in B2 ?

Does B3 get incremented ?

Bob

You cannot teach a man anything;  you can only help him find it within himself..........Galileo Galilei

## #31 2013-04-28 04:40:48

JoshH
Member

Offline

### Re: Greetings!

the B3 cell seams to remain at zero and never changes.

## #32 2013-04-28 04:42:21

JoshH
Member

Offline

### Re: Greetings!

in b3 my cell reads =IFERROR(IF(FIND(1111,B2)>0,B3+1,B3),B3)

## #33 2013-04-28 04:43:17

bob bundy
Moderator

Online

### Re: Greetings!

try this:

=IFERROR(IF(FIND(1111,B2)>0,"yes","no"),"no")

That works for me.

Bob

You cannot teach a man anything;  you can only help him find it within himself..........Galileo Galilei

## #34 2013-04-28 04:46:03

bob bundy
Moderator

Online

### Re: Greetings!

With your b3 stuff in the formula I get  circular reference error.  Not surprising as the formula is sitting in the space you want to store a number.

thinking....................

Bob

You cannot teach a man anything;  you can only help him find it within himself..........Galileo Galilei

## #35 2013-04-28 04:48:02

JoshH
Member

Offline

### Re: Greetings!

ok the yes and no one worked.

## #36 2013-04-28 04:49:10

JoshH
Member

Offline

### Re: Greetings!

now would there be a way to run number tally's in the same bracket and after 10k games have it reset ?

## #37 2013-04-28 04:51:05

bob bundy
Moderator

Online

### Re: Greetings!

in the same bracket

?? not following you ??

You cannot teach a man anything;  you can only help him find it within himself..........Galileo Galilei

## #38 2013-04-28 04:56:59

JoshH
Member

Offline

### Re: Greetings!

the cell underneath the random coin flips I was trying to get number of wins in there and I can't figure out how to have that work. The yes/no worked but I am still kinda lost on how to get the number of wins to come out.

## #39 2013-04-28 04:59:17

JoshH
Member

Offline

### Re: Greetings!

something else I did was on a separate sheet I did the same problem but took a different approach I made ten separate sells across a =RANDBETWEEN(0,1). I was thinking maybe there would be a way to have all those cell's join in a formula to figure out the average. I'll post a link of what I did in the separate cell. I am terrible at explaining what I was thinking lol! sorry

## #40 2013-04-28 05:01:14

JoshH
Member

Offline

### Re: Greetings!

albums/cc214/Hayabusakota/ScreenShot2013-04-27at30008PM.png

## #41 2013-04-28 05:02:15

bob bundy
Moderator

Online

### Re: Greetings!

columns A to J hold the ten coin flips.

column K builds the ten digit o/1 value

column L has the IFERROR...... formula returning YES or NO

Copy 20 times down the page.

At the bottom of the L column use COUNTIF to count the YES values.

If this works, extend to 10000 rows.

Bob

You cannot teach a man anything;  you can only help him find it within himself..........Galileo Galilei

## #42 2013-04-28 05:02:29

JoshH
Member

Offline

### Re: Greetings!

i218 .photobucket. com

## #43 2013-04-28 05:11:15

JoshH
Member

Offline

### Re: Greetings!

just wondering how do I build the ten digit 0/1 value into one cell?

## #44 2013-04-28 05:17:41

bob bundy
Moderator

Online

### Re: Greetings!

This is messy but it will do it I think

k = 1000000000*A + 100000000*B + 10000000*C + 1000000*D  + 100000*E + 10000*F + 1000*G + 100*H + 10*I + J

Or you could build a string version as you can 'add' letters without all those powers of ten.

Bob

You cannot teach a man anything;  you can only help him find it within himself..........Galileo Galilei

## #45 2013-04-28 05:40:31

bob bundy
Moderator

Online

### Re: Greetings!

Better idea.  Don't use numbers at all.

IF(RANDBETWEEN(0,1)=1,"H","T") to get an H or T.

Then use CONCATENATE to build a ten letter word.

I'm going to see if I can get my head around how you avoid 10000 rows of formulas.

It's 20.40 BST so I'm going to log off for now and come back to this tomorrow evening.

Bob

You cannot teach a man anything;  you can only help him find it within himself..........Galileo Galilei

## #46 2013-04-28 05:43:15

JoshH
Member

Offline

### Re: Greetings!

No luck with that formula up there I was trying to build a string but I don't know how to have the string represent the number in each cell while grouped in the cell I am adding the totals in.

## #47 2013-04-28 05:45:28

JoshH
Member

Offline

### Re: Greetings!

alright sounds good to me going to see if I know anyone locally that can help me figure this one out.

## #48 2013-04-28 13:23:41

JoshH
Member

Offline

### Re: Greetings!

Hey Bob here you go a screen cap of the current problem almost solved I think.

albums/cc214/Hayabusakota/ScreenShot2013-04-27at30008PM-1.png

this is part one.

JoshH
Member

Offline

## #50 2013-04-28 16:58:21

bob bundy
Moderator

Online

### Re: Greetings!

hi Josh,

It's 8 am here in the UK.  I'm out all morning at a dance show rehearsal so I'll have to leave this until this afternoon.  That last image looks like you are just about there.

Bob

You cannot teach a man anything;  you can only help him find it within himself..........Galileo Galilei