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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#8
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Reply |
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) |