Trouble with a Formula I need help with???

[MUmfleet]

Here is my dilemna. I am tryiing to total up multiple teams etc on a soccer
team and have cell's say "Win", "Lose", "Tie". The "Tie" portion is what I
am having an issue with. So I have Teams 1 through 10, and each week they
play this same set of teams. So week 1 Team 1 plays Team 2, and week 2 Team
1 plays Team 3 and Team 2 plays Team 4, Etc. So, if in Cell A1 = team 1
name, Cell A2 = That weeks score, Cell A3 = Team 2 Name, Cell A4 = Score. I
am able to build the Function for it to tell if A2>A4 then display "Win" or
"Lose". Example is... =IF(E5>H5,"WIN","LOSE"). Where I am struggling is
with adding the "If E5 is Equal to H5 then display "Tie".

Please help...

Mike

 

[Bob Umlas]

=IF(E5>H5,"WIN",IF(E5=H5,"TIE","LOSE"))
Bob Umlas
Excel MVP

 

[MUmfleet]

Bob,
Thank you for the very quick response. However when I paste your formula in
my cell it gives me a "TRUE" as the end result rather than the Win, Lose, or
Tie.
Mike

 

[Fred Smith]

It works for me. You must have entered it incorrectly. Try copying and
pasting it again.

Regards,
Fred

 

[MUmfleet]

Fred, Thanks I kept trying it and trying it. And I was doing the cut and
paste. What I struggled with is if A1 and A2 are say 3, in that formula it
would be a tie, but if I changed A1 to be 2, then it was not recalculating
it. To which I have not figured out yet. Also, if there is nothing in
either A1 or A2 it shows to be a TIE, not just empty. Do you have a fix for
that?

Mike

 

[Fred Smith]

If it's not recalculating check your settings
(Tools>Options>Calculation>Automatic)

To check for empty cells, use:
=IF(OR(E5="",H5=""),"",IF(E5>H5,"WIN",IF(E5=H5,"TIE","LOSE")))

I presume you've solved the problem with the formula returning TRUE, as you
didn't mention it in this post.

Regards,
Fred

 

[MUmfleet]

Thank You Fred, it is all working perfectly. I'm not sure why it wasnt
recalulating but it is now. Thank you, I appreciate your assistance.

Mike

 

[Fred Smith]

Recalculation gets set by the first file you load. It stays that way until
reset manually or by a macro. You probably have a file somewhere which has
recalc set to manual.

Hope this helps,
Fred.