World Cup 2010 spreadsheet
 

Hi All & Happy Christmas & New Year,
I'm working on a World Cup 2010 spreadsheet.
I've got the group tables & matches sorted out but my problem is as
follows.....

In the group tables I've got the Played, Won, Drawn & Lost etc headings &
the results of each game will be displayed under these headings.
Before any games are played though the tables are all showing that all teams
have Played 3 & Drawn 3 & have 3 Points...........
(I've got seperate reference cells with formulae where the scores determine
Won, Drawn or Lost for each team in each game - A11 is Won, B11 Draw, C11
lost for Team A then I've got the same principle in seperate cells for Team B
on the other side of the fixture).
This is where the problem lies.......
In the Draw cell I'm using =IF(G4=H4,1,0) so even when these two cells are
empty it's seeing this as a TRUE result so it's being called a Draw.
(when I input other scores the table works as it should)
My Question is how can I get the tables to show 0 Draws, 0 Played & 0 Points
before the start of the World Cup) ?

I haven't formatted any cells, I've just gone with default formatting,
should I declare the Score Cells (G4 & H4) as numbers?

I can go into more detail of all relevant cells & formulae used in them to
update the tables.

Thanks in advance for any help on this one
John

World Cup 2010 spreadsheet
 

Hi,
try this

=IF(G4="",0,if(G4=H4,1,0))

"Originalgoth" wrote:

Hi All & Happy Christmas & New Year,
I'm working on a World Cup 2010 spreadsheet.
I've got the group tables & matches sorted out but my problem is as
follows.....

In the group tables I've got the Played, Won, Drawn & Lost etc headings &
the results of each game will be displayed under these headings.
Before any games are played though the tables are all showing that all teams
have Played 3 & Drawn 3 & have 3 Points...........
(I've got seperate reference cells with formulae where the scores determine
Won, Drawn or Lost for each team in each game - A11 is Won, B11 Draw, C11
lost for Team A then I've got the same principle in seperate cells for Team B
on the other side of the fixture).
This is where the problem lies.......
In the Draw cell I'm using =IF(G4=H4,1,0) so even when these two cells are
empty it's seeing this as a TRUE result so it's being called a Draw.
(when I input other scores the table works as it should)
My Question is how can I get the tables to show 0 Draws, 0 Played & 0 Points
before the start of the World Cup) ?

I haven't formatted any cells, I've just gone with default formatting,
should I declare the Score Cells (G4 & H4) as numbers?

I can go into more detail of all relevant cells & formulae used in them to
update the tables.

Thanks in advance for any help on this one
John

World Cup 2010 spreadsheet
 

Thanks Eduardo,

That works a charm.

I've used the "Yes" Button to show that this post answered my question.

Thanks Again & Best Wishes
John


"Eduardo" wrote:

Hi,
try this

=IF(G4="",0,if(G4=H4,1,0))

"Originalgoth" wrote:

Hi All & Happy Christmas & New Year,
I'm working on a World Cup 2010 spreadsheet.
I've got the group tables & matches sorted out but my problem is as
follows.....

In the group tables I've got the Played, Won, Drawn & Lost etc headings &
the results of each game will be displayed under these headings.
Before any games are played though the tables are all showing that all teams
have Played 3 & Drawn 3 & have 3 Points...........
(I've got seperate reference cells with formulae where the scores determine
Won, Drawn or Lost for each team in each game - A11 is Won, B11 Draw, C11
lost for Team A then I've got the same principle in seperate cells for Team B
on the other side of the fixture).
This is where the problem lies.......
In the Draw cell I'm using =IF(G4=H4,1,0) so even when these two cells are
empty it's seeing this as a TRUE result so it's being called a Draw.
(when I input other scores the table works as it should)
My Question is how can I get the tables to show 0 Draws, 0 Played & 0 Points
before the start of the World Cup) ?

I haven't formatted any cells, I've just gone with default formatting,
should I declare the Score Cells (G4 & H4) as numbers?

I can go into more detail of all relevant cells & formulae used in them to
update the tables.

Thanks in advance for any help on this one
John