Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Trouble with formula | Excel Worksheet Functions | |||
trouble with formula | Excel Discussion (Misc queries) | |||
Formula trouble | Excel Discussion (Misc queries) | |||
still having trouble with this formula | Excel Discussion (Misc queries) | |||
I'm new at this - having trouble with a formula | Excel Discussion (Misc queries) |