I need a formula to compare scores

April 30, 2011 at 18:33:10
Specs: Windows XP
I'm doing an excel spreadsheet on sports and I want to compare two values in different columns and then I want this formula to give me the team's name in next column example
a1 b1 c1 d1
chicago 100 NY 90 I want the formula to give me Chicago in E1

See More: I need a formula to compare scores

Report •

April 30, 2011 at 18:52:17
Even though you didn't say it, I assume you want Chicago in E1 because their score is higher. I also assume there will never be a tie.

=IF(B1>D1, A1, C1)

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.

Report •

April 30, 2011 at 19:25:39
Thank you so much derbydad you assumed it right!! Thanks!

Report •

April 30, 2011 at 19:55:05
Is it possible to make a standings chart with the formula you helped me before. Something that updates when I type in the results of the game.....and adding wins and losses thank you.

Report •
Related Solutions

Ask Question