Trouble with a Formula I need help with???

  • Thread starter Thread starter MUmfleet
  • Start date Start date
M

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,
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
 
It works for me. You must have entered it incorrectly. Try copying and
pasting it again.

Regards,
Fred
 
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
 
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
 
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
 
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.
 
Back
Top