1. 11-23-10 09:31 PM #1
    cappinthepigs
    cappinthepigs's Avatar Become A Pro!
    Join Date: 10-07-09
    Posts: 1,864
    Betpoints: 67

    SIMPLE Excel Formula Problem

    Hey guys, new to this part of the forum, but heard this is definetly the place to go for questions like this.

    This will probably be a simple question for most of you, but I have NO CLUE how to do this.

    I have a spreadsheet for tracking purposes of my own bets, done myself that's why it sucks so badly! But I have fields for Team A Score, Team B Score, O/U #, and a O/U Result field.

    In the result field I have this formula =IF((K3>G3),"OVER","Under") that tells me if the game went over or under.... How do I make it show a push is my only question.

    Thank You many times for any help!

    Cappin
    Reply With Quote Reply With Quote
  2. 11-23-10 09:55 PM #2
    rfr3sh
    Blind Knucklehead
    rfr3sh's Avatar Become A Pro!
    Join Date: 11-07-09
    Posts: 10,229
    Betpoints: 604

    techonthenet.com/excel/formulas/if_nested.php
    Points Awarded:

    cappinthepigs gave rfr3sh 1 SBR Point(s) for this post.
    Reply With Quote Reply With Quote
  3. 11-23-10 10:11 PM #3
    Rod_M
    Rod_M's Avatar Become A Pro!
    Join Date: 10-31-09
    Posts: 1,282
    Betpoints: 3329

    =if(k3=g3,"push",if(k3>g3,"over","under" ))
    Reply With Quote Reply With Quote
  4. 11-23-10 10:13 PM #4
    Emily_Haines
    Emily_Haines's Avatar Become A Pro!
    Join Date: 04-14-09
    Posts: 15,888
    Betpoints: 15313

    ...........
    Reply With Quote Reply With Quote
  5. 11-23-10 10:17 PM #5
    cappinthepigs
    cappinthepigs's Avatar Become A Pro!
    Join Date: 10-07-09
    Posts: 1,864
    Betpoints: 67

    Quote Originally Posted by rfr3sh View Post
    techonthenet.com/excel/formulas/if_nested.php
    Many Thanks! I learned something there!
    Reply With Quote Reply With Quote
  6. 11-23-10 10:20 PM #6
    cappinthepigs
    cappinthepigs's Avatar Become A Pro!
    Join Date: 10-07-09
    Posts: 1,864
    Betpoints: 67

    Quote Originally Posted by Rod_M View Post
    =if(k3=g3,"push",if(k3>g3,"over","under"))
    Thank You as well Rod!

    I'm really trying to figure all this stuff out, could be quite handy!

    If I post what I'm using will yall look at it and see if it's retarded or not?

    Anybody that wants can steal this piece of crap too! LOL
    Attached Files
    Reply With Quote Reply With Quote
  7. 11-23-10 10:20 PM #7
    cappinthepigs
    cappinthepigs's Avatar Become A Pro!
    Join Date: 10-07-09
    Posts: 1,864
    Betpoints: 67

    Just started doing this so I THINK I'm on the right track, but I'm learning everything as I go.
    Reply With Quote Reply With Quote
  8. 11-24-10 11:19 AM #8
    uva3021
    uva3021's Avatar Become A Pro!
    Join Date: 03-01-07
    Posts: 537
    Betpoints: 381

    Looks good, i hope you don't mind but I felt compelled to make a few changes and you cann use it if you want to, just enter the score and units wagered, everything else is automated

    when i saved it said some features may be incompatible with excel 2003, not sure if you have that version or not, i assume you do since it asked me

    it should be ok though, all i did was use "IF(AND...."
    Attached Files
    Reply With Quote Reply With Quote
Top
« Previous Thread | Handicapper Think Tank | Next Thread »