Another Excel Formula Question

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • Professor1215
    SBR High Roller
    • 11-28-11
    • 216

    #1
    Another Excel Formula Question
    Good day gentlemen. I hope I can ask this in a way that will 1) make sense and will 2) generate a solution.

    I have a worksheet that gives me a numerical value for Team A vs. Team B. Whichever value is higher is the team with the advantage. In this example I have the Rangers at 6.366 and the Mariners and 3.812.

    I have a "MAX" formula set up to automatically tell me which team has the higher value in the next row. (6.366)

    That being said, how do I set up a formula to insert the word "Rangers" right next to the cell that contains the 6.366 MAX formula value?

    Any help would be greatly appreciated.
  • Waterstpub87
    SBR MVP
    • 09-09-09
    • 4102

    #2
    =if(Rangers>Mariners,click Rangers, click Mariners)

    Use the numbers for the first part , the if formula looks like =logical arguement, result if true, result if false.

    If it gives you back ?name or something like that, put quotations around any text
    Comment
    • Professor1215
      SBR High Roller
      • 11-28-11
      • 216

      #3
      Wow, thank you so much! If I could give you points, I would.
      Comment
      • Waterstpub87
        SBR MVP
        • 09-09-09
        • 4102

        #4
        Originally posted by Professor1215
        Wow, thank you so much! If I could give you points, I would.
        Don't worry about it. Any other excel questions?
        Comment
        • JohnAnthony
          SBR Hall of Famer
          • 04-30-09
          • 5110

          #5
          Originally posted by Waterstpub87

          Don't worry about it. Any other excel questions?
          Now that's a poster to keep.
          "I have never seen a wild thing feel sorry for itself. A little bird will fall dead, frozen from a bough, without ever having felt sorry for itself."

          - D.H. Lawrence
          Comment
          SBR Contests
          Collapse
          Top-Rated US Sportsbooks
          Collapse
          Working...