Math Is Fun Forum
  Discussion about math, puzzles, games and fun.   Useful symbols: √ ∞ ≠ ≤ ≥ ≈ ⇒ ∈ Δ θ ∴ ∑ ∫ π -

Login

Username

Password

Not registered yet?

#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

Offline

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

link name

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

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

 

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

bob bundy
Moderator

Offline

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

Offline

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

Offline

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

Offline

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

Offline

Re: Greetings!

How about this:

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

Offline

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

Offline

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.

FIND HHHH instead.

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.

 

#49 2013-04-28 13:25:03

JoshH
Member

Offline

Re: Greetings!

 

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

bob bundy
Moderator

Offline

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.  smile

Bob


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

Board footer

Powered by FluxBB