chiefjay Posted April 25, 2008 Share Posted April 25, 2008 I'm not a great excel user. I need to create an if / then type of formula or something similar. The formula would be in a cell to record a win or a loss or a tie for a game. So lets say, the Tigers 5, Firebirds 3 The next cell should have a formula to record the winner which I can do but I need it to record a tie if the game was a tie. Here is my formula for the winner. =IF(E5>E7,E4,E6) This of coruse will pick the team with the higher score in their cell and put in the new cell with the formula. I need something added to put tie there if the scores are =. I know this is easy but I just don't use these formulas that much. Thanks, CJ Quote Link to comment Share on other sites More sharing options...
Grits and Shins Posted April 25, 2008 Share Posted April 25, 2008 Use a compound IF statement IF (A > B, true condition, false condition) Your false condition can be another IF statement =IF(E5>E7,E4,IF(E5=E7,E?,E6)) Quote Link to comment Share on other sites More sharing options...
chiefjay Posted April 25, 2008 Author Share Posted April 25, 2008 Use a compound IF statement IF (A > B, true condition, false condition) Your false condition can be another IF statement =IF(E5>E7,E4,IF(E5=E7,E?,E6)) Thx, I'll give it a whirl, I figured as such but couldn't figure it out. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.