#### 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