IF function and ISBLANK function in same formula

Truk

New Member
Joined
Mar 26, 2011
Messages
2
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 Workbook
ABCDEFGHI
1Soccer Results 2011 - U9 Vipers
2
3DATEOPPONENTSUSTHEMAway/Home TeamSeason Information
426/03/2011U9 CARNIVAL
52/04/2011DRAWGAMES PLAYED1
6WINS0
7LOSSES0
8DRAWS1
9
10% OF WINS TO LOSSES0.00
11
12GOALS FOR0
13GOALS AGAINST0
14Average goals for per game0.00
15Average goals against per game0.00
16
Results
Excel 2003
Cell Formulas
RangeFormula
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!
Entered with Ctrl+Shift+Enter. If entered correctly, Excel will surround with curly braces {}.
 

Excel Facts

How to find 2nd largest value in a column?
MAX finds the largest value. =LARGE(A:A,2) will find the second largest. =SMALL(A:A,3) will find the third smallest

Forum statistics

Threads
1,224,594
Messages
6,179,792
Members
452,942
Latest member
VijayNewtoExcel

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top