• Welcome to #1 Roulette Forum & Message Board | www.RouletteForum.cc.

News:

Progression bets are nothing more than different size bets on different spins. You could get lucky and win big, or unlucky and lose even more.

Main Menu
Popular pages:

Roulette System

The Roulette Systems That Really Work

Roulette Computers

Hidden Electronics That Predict Spins

Roulette Strategy

Why Roulette Betting Strategies Lose

Roulette System

The Honest Live Online Roulette Casinos

excel help

Started by DaDee, Mar 24, 11:09 AM 2013

Previous topic - Next topic

0 Members and 1 Guest are viewing this topic.

DaDee

Does anyone know how to do triple OR statements in excel?

Or maybe have a dozens spreadsheet I can use.

I want to have the dozens from numbers listed in one column like something like this,

1
3
2
1
2
3
2
2

starkygold

you can use VLOOKUP or COUNTIF function.

DaDee

Quote from: starkygold on Mar 24, 11:49 AM 2013
you can use VLOOKUP or COUNTIF function.

Thanks I figured it out. Back to testing

ADulay

Or a brute force way would be something along these lines.  Still fast enough to update a few hundred thousand decisions with no problems.

=OR(B5=1,B5=4, B5=7,B5=10,B5=13,B5=16,B5=19,B5=22,B5=25,B5=28,B5=31,B5=34)

Something like that will pick all of the "first column" numbers from a result at (B5).  Obviously just copy/paste it all the way down the sheet for an unlimited amount of random or previously copied numbers.

I've actually built and used a nice sheet that tracks every number at every position with this basic calculation!

Every column, dozen, EC and pretty much any sector or combination of numbers you could want and it's all done with the "=OR" function.

AD

-