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
|