Hi,
I have posted here once before with great success and hope that I can
experience the same this time round - my thanks in advance.

This should be easy but is beyond my newbish capacities in excel.

I am updating a sports competition ladder. There are two aspects to
compiling the table I would like to automate but have been unable to
find out how via the excel documentation.

The aspects are.

1. When a team loses by a margin of seven points or less below the
total points scored by the winning team then the team is awarded a
single "1" bonus point that contributes to their overall competition
points tally.
2. When a team scores four tries or more they are likewise awarded a
bonus point.

I require formulas that will automatically calculate the bonus points
into a cell.

SITUATION ONE
cell 1 = Points For (eg. 17)
Cell 2 = Points Against (eg. 24).
In this instance the team did not win. They scored 17 points and the
winning team scored 24 points. Therefore the team lost but lost by
seven points and is therefore entitled to one (1) bonus point.
SOLUTION NEEDED - I need a formula that will calculate whether cell 2
is seven or less than cell 1, and if so automatically place a total of
"1" in cell 3.

SITUATION 2
Cell 1 = Tries Scored (eg. 5)
In this instance the team has scored five tries. They have scored more
than four tries or more and is therefore entitled to one (1) bonus
point.
SOLUTION NEEDED - I need a formula that will scan the number in cell 1.
If this number is 4 or more, then a total of "1" should be automatically
placed in Cell 2.

I have looked into the excel help but to no avail and the search terms
are so broad it was a nightmare trying to search the forums.

My thanks in advance to anyone that can help me.

Kind Regards
Shaun in Sydney.


--
shaunl
------------------------------------------------------------------------
shaunl's Profile: http://www.excelforum.com/member.php...o&userid=25140
View this thread: http://www.excelforum.com/showthread...hreadid=527886