Issue getting Excel to give me a win or lose instead of true or false for probability

Well I have this problem for school that I am having issues with it is

You are going to play a game where you bet a dollar and get to flip a coin ten times. If you get four heads in a row, you win. If you make the tenth flip without getting four heads in a row, you lose. Run this game ten thousand times. Approximately what is the probability that you will win?

It has to be done on an excel spreadsheet with standard formulas and not macros well i got it almost figured out but the formula my girlfriend figured up for me keeps coming back true/false and excel will not allow me to do a countif function on true/false answers so I need to get the formula to come up win or lose instead any help will be greatly appreciated. The formula she made for me is below.

=OR(ISNUMBER(SEARCH(REPT({"1"},4),A3&B3&C3&D3&E3&F3&G3&H3&I3&J3)))

heads=1 tails=0 on my spreadsheet

if anyone knows of a way maybe to do it in a cell next to the true/false outcome to make it say win/lose also would work i just need a way to get this figured out ive been working on the same 3 problems for the last 5 days and seem to be going no where with them

We won't do your homework but happy to guide you. If your formula above is giving you true and false why not just wrap an if statement around it?

Please Login or Register  to view this content.

I assume A3 to J3 are all random number generators rounded to 1 or 0 and that you've copied that down 10,000 lines to simulate the games

So did the if statement fix your problem?

yes it did and thank you so much i have literally been working on these 3 problems for the past 5 days and this was the final one again thank you now i can finally get some sleep

Great. I think we're on the same page with the set up. 10 columns representing each roll of the die but surely you'll copy that down 10,000 rows as each row of 10 die rolls is a single game isn't it.

yes it is setup for 10k times but i didnt want to copy it down all the way till i was sure everything would work right so i wouldnt have to start from scratch incase it was wrong i had it setup with only 5 rows until i was sure all the formatting was correct first. I figured starting small would be better than having to scroll all the way down each time i needed to edit it or delete the whole thing each time.

Great. Glad it's all working. If you haven't already done so you should mark as [solved].

And a little tip. If you do copy down the 10,000 rows and decide to change the formula you don't have to drag the new formula over the top. Double click on the square in the bottom right of the cell and it will auto copy over the cells below