Poker Forum

Over 1,246,000 Posts!

REGISTER
Subscribe to FTR web feed
Already Registered?      Username:    Password:   Remember      Forgot Password

Poker Forum

  > 

FTR Community

  > 

any excel sharks around here?

  
 
LinkBack Thread Tools Display Modes
littleogre
Old 02-26-2008, 05:13 PM     Post subject: any excel sharks around here? #1 (permalink)  

Join Date: Oct 2004
Posts: 1,344
littleogre has a little shameless behaviour in the past
 ok i have a basic work sheet that tells me that if you bet every 2nd half over the last 279 nba games where you were geting atleast a .5 advantage over the game line you would be up 21 units. i just use the formula =sum(g2:g272).
The problem is that is the only formula that i know. i keep the differnce between the game line and half time line in column E. I keep the adding in column g. Meaning that if the bet was a win a 1 is put in the cell if it was a loss -1.1 is put in the cell. Now lets say i want to get a sum but i only want to use games where their column G cell =8. I will try to draw a crude example

G1=8 E1=1
G2=4 E2=1
g3=5 E3=1

now as we can see if we just use the basic sum formula we will get 3. How do i get it to only use the games where the g column is 8?
Reply With Quote

Play for FREE and practice your game at...

Join the FTR Poker Forum to disable these banners and start posting!
euphoricism
Old 02-26-2008, 05:49 PM #2 (permalink)  
euphoricism's Avatar
4-of-a-Kind

Join Date: Mar 2005
Location: Your place or my place
Posts: 3,610
euphoricism
Send a message via AIM to euphoricism
tutorial:
http://personal-computer-tutor.com/IFstatement.htm
<Staxalax> Honestly, #flopturnriver is the one thing that has improved my game the most.
Directions to join the #flopturnriver Internet Relay Chat - Come chat with us!
 
Reply With Quote
Reply
Latest Poker News
KoRnholio Old 05-26-2012, 03:08 PM    Australia Legalized Online Poker coming up in next 6 to 12 Months
According to an email sent out by Mark Bryan, a gaming analyst at Merrill Lynch, the Australian government plans to legalize online poker sometime in the next six to 12 months. This move will coincide ...

« Previous Thread | Next Thread »
Thread Tools
Display Modes
Linear Mode Linear Mode

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


All times are GMT. The time now is 12:41 AM.

Contact Us - Archive - Top

FTR Testimonials

All content
© FlopTurnRiver.com 		Advertising  |   Partners  |   Testimonials  |   T&C  |   Contact Us  |   FTR News & Press  |   Site Map  |   Search FTR

Full Tilt  |   Titan Poker  |   UltimateBet  |   Poker Stars  |   Ladbrokes Bonus  |   Sportsbook  |   Cake Poker  

Play Texas Holdem Online, Online Texas Holdem Strategy, & Poker Forum
This is not a gambling website.