World Cup 2010 Spreadsheet

[Originalgoth]

Hi All & Happy Christmas & New Year,
I'm working on a World Cup spreadshhet. (Excel 2003)

In one section of it I've got the Group table
A B C D E F G H I

P W D L F A Pts GD
S. Africa

Below each table I've got the fixtures & these are what feed the above table.

Beside each team in the fixtures I've got seperate cells for W,D, & L. These
cells are each comparing the scores of each fixture & if True they're
resulting 1, if False they're 0.........

W D L Pts Team A Score Score Team B Pts W
D L
(The W to Pts are all hidden - they're formatted as White text)

The problem I'm having is with the Drawn games - even when the score cells
are empty (before any games have even been played) it's seeing this as True
so it's putting a "1" in the table for all teams so I'm ending up with a
table that shows that all teams have Played 3 & Drawn all 3 !!!!

For Draw I'm using
=IF(G11=H11,1,0)

The games Played are calculated by =Sum(cells W, D, & L) so I know that this
is why this isn't working as wanted, I know that once I get the Draw to = "0"
that this will sort out the Played bit.

What do I need to do to get the Draw Cell for each team in each fixture to
be "0" until a score has been entered?

Thanks in advance for any & all help.
John

 

[Pete_UK]

Try this:

=IF(OR(G11="",H11=""),"",IF(G11=H11,1,0))

so that until you put something in G11 and in H11 the formula will
make the cell look blank. You might want to change the ,"", bit to ,0,
depending on your logic.

Hope this helps.

Pete