World Cup 2010 spreadsheet

O

Originalgoth

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
 
O

Originalgoth

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

World Cup 2010 Spreadsheet 1
Tennis Scorecard Help 1
index/large..help please 9
SumIF or CountIF 4
World cup spreadsheet help 7
Sports Tipping Formula! 1
Moving Formulas when Sorting 3
General Help 1

Top