Another Excel Formula Question

[Professor1215]

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]

=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

[Professor1215]

Wow, thank you so much! If I could give you points, I would.

[Waterstpub87]

Wow, thank you so much! If I could give you points, I would.

Don't worry about it. Any other excel questions?

[JohnAnthony]

Don't worry about it. Any other excel questions?

Now that's a poster to keep.