SIMPLE Excel Formula Problem

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • cappinthepigs
    SBR MVP
    • 10-07-09
    • 1864

    #1
    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
  • rfr3sh
    SBR Posting Legend
    • 11-07-09
    • 10229

    #2
    techonthenet.com/excel/formulas/if_nested.php
    Comment
    • Rod_M
      SBR MVP
      • 10-31-09
      • 1282

      #3
      =if(k3=g3,"push",if(k3>g3,"over","under" ))
      Comment
      • Emily_Haines
        SBR Posting Legend
        • 04-14-09
        • 15917

        #4
        ...........
        Comment
        • cappinthepigs
          SBR MVP
          • 10-07-09
          • 1864

          #5
          Originally posted by rfr3sh
          techonthenet.com/excel/formulas/if_nested.php
          Many Thanks! I learned something there!
          Comment
          • cappinthepigs
            SBR MVP
            • 10-07-09
            • 1864

            #6
            Originally posted by Rod_M
            =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
            Comment
            • cappinthepigs
              SBR MVP
              • 10-07-09
              • 1864

              #7
              Just started doing this so I THINK I'm on the right track, but I'm learning everything as I go.
              Comment
              • uva3021
                SBR Wise Guy
                • 03-01-07
                • 537

                #8
                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
                Comment
                SBR Contests
                Collapse
                Top-Rated US Sportsbooks
                Collapse
                Working...