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 A2A4 then display "Win" or
"Lose". Example is... =IF(E5H5,"WIN","LOSE"). Where I am struggling is
with adding the "If E5 is Equal to H5 then display "Tie".

Please help...

Mike

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

"MUmfleet" wrote in message
...
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 A2A4 then display "Win"
or
"Lose". Example is... =IF(E5H5,"WIN","LOSE"). Where I am struggling is
with adding the "If E5 is Equal to H5 then display "Tie".

Please help...

Mike

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


"Bob Umlas" wrote:

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

"MUmfleet" wrote in message
...
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 A2A4 then display "Win"
or
"Lose". Example is... =IF(E5H5,"WIN","LOSE"). Where I am struggling is
with adding the "If E5 is Equal to H5 then display "Tie".

Please help...

Mike

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

Regards,
Fred


"MUmfleet" wrote in message
...
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


"Bob Umlas" wrote:

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

"MUmfleet" wrote in message
...
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 A2A4 then display
"Win"
or
"Lose". Example is... =IF(E5H5,"WIN","LOSE"). Where I am struggling
is
with adding the "If E5 is Equal to H5 then display "Tie".

Please help...

Mike

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" wrote:

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

Regards,
Fred


"MUmfleet" wrote in message
...
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


"Bob Umlas" wrote:

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

"MUmfleet" wrote in message
...
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 A2A4 then display
"Win"
or
"Lose". Example is... =IF(E5H5,"WIN","LOSE"). Where I am struggling
is
with adding the "If E5 is Equal to H5 then display "Tie".

Please help...

Mike

If it's not recalculating check your settings
(ToolsOptionsCalculationAutomatic)

To check for empty cells, use:
=IF(OR(E5="",H5=""),"",IF(E5H5,"WIN",IF(E5=H5,"TI E","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" wrote in message
...
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" wrote:

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

Regards,
Fred


"MUmfleet" wrote in message
...
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


"Bob Umlas" wrote:

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

"MUmfleet" wrote in message
...
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 A2A4 then display
"Win"
or
"Lose". Example is... =IF(E5H5,"WIN","LOSE"). Where I am
struggling
is
with adding the "If E5 is Equal to H5 then display "Tie".

Please help...

Mike