Trouble with a Formula I need help with???
 

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

Trouble with a Formula I need help with???
 

=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

Trouble with a Formula I need help with???
 

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

Trouble with a Formula I need help with???
 

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

Trouble with a Formula I need help with???
 

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

Trouble with a Formula I need help with???
 

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

Trouble with a Formula I need help with???
 

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

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

Trouble with a Formula I need help with???
 

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.

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

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