Hi,
I am trying to get multiple outcomes for 1 cell. I have succeeded so far with 3 outcomes (win, loss or draw), but I can't seem to get the fourth outcome. In cell F5, I wish to receive an outcome of a blank cell if nothing is entered into C5. However, I have already written in that if C5 and D5 are the same, then the word DRAW should appear. I tried using the ISBLANK function in the formula a number of ways, but cannot seem to get it to work.
Your help is much appreciated.
PS
Excel 2003
Excel 2003
Entered with Ctrl+Shift+Enter. If entered correctly, Excel will surround with curly braces {}.
I am trying to get multiple outcomes for 1 cell. I have succeeded so far with 3 outcomes (win, loss or draw), but I can't seem to get the fourth outcome. In cell F5, I wish to receive an outcome of a blank cell if nothing is entered into C5. However, I have already written in that if C5 and D5 are the same, then the word DRAW should appear. I tried using the ISBLANK function in the formula a number of ways, but cannot seem to get it to work.
Your help is much appreciated.
PS
Excel 2003
Excel Workbook | |||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|
A | B | C | D | E | F | G | H | I | |||
1 | Soccer Results 2011 - U9 Vipers | ||||||||||
2 | |||||||||||
3 | DATE | OPPONENTS | US | THEM | Away/Home Team | Season Information | |||||
4 | 26/03/2011 | U9 CARNIVAL | |||||||||
5 | 2/04/2011 | DRAW | GAMES PLAYED | 1 | |||||||
6 | WINS | 0 | |||||||||
7 | LOSSES | 0 | |||||||||
8 | DRAWS | 1 | |||||||||
9 | |||||||||||
10 | % OF WINS TO LOSSES | 0.00 | |||||||||
11 | |||||||||||
12 | GOALS FOR | 0 | |||||||||
13 | GOALS AGAINST | 0 | |||||||||
14 | Average goals for per game | 0.00 | |||||||||
15 | Average goals against per game | 0.00 | |||||||||
16 | |||||||||||
Results |
Cell Formulas | ||
---|---|---|
Range | Formula | |
F5 | =IF(C5>D5,"WIN",IF(C5C5=D5,"DRAW",))) | |
I5 | =SUM(I6:I8) | |
I10 | =(I6/I5) *100 | |
I12 | =SUM(C5:C25) | |
I13 | =SUM(D5:D25) | |
I14 | =SUM(I12/I5) | |
I15 | =SUM(I13/I5) |
#VALUE!