moppyau
New member
- Joined
- May 6, 2013
- Messages
- 4
- Reaction score
- 0
- Points
- 0
- Location
- Australia
- Excel Version(s)
- Excel2013
Hi All.
I've attached a spreadsheet that I'm having a bit of a problem with. The formula in J2 awards 4 points if St. Monicas defeats another team & awards 2 points in the case of a draw. My problem is that if there are no scores entered in columns D or F it awards 2 points as blank cells are counted as equal. Is it possible for excel to ignore cells that are empty in an IF formula?
Many thanks in advance
Mop
I've attached a spreadsheet that I'm having a bit of a problem with. The formula in J2 awards 4 points if St. Monicas defeats another team & awards 2 points in the case of a draw. My problem is that if there are no scores entered in columns D or F it awards 2 points as blank cells are counted as equal. Is it possible for excel to ignore cells that are empty in an IF formula?
Many thanks in advance
Mop