Excel Help.. PLEASE...

Giganews Newsgroups
Subject: Excel Help.. PLEASE...
Posted by:  Brucey (bruc3yMOSP…@blueNOSPAMyonder.co.uk)
Date: Mon, 27 Oct 2003

I am using M$ Excel that I got with Office XP...

I am making a Rugby World Cup spreadsheet...

With scores, tries scored, total points, and so on....

But I am stuck....

I am after a formula that works out that IF a team has scored 5 tries
they get a bonus point, IF the team wins by more than 7 points they
get a bonus point...  Also one that works out that a team has won, and
entering that into the Win column...

I want it all to do that from when I enter the scores of the teams,
and tries score...

also, after a formula that works out from the quarter final results
and the semi final teams, and from the semi final results to show
which team goes where for the final and 3rd/4th place play-offs....

Any ideas??

All help appreciated in advance..

Replies