Re: Sports Comp Ladder tabulating help needed


Hi Pete,
I used the spread*** over the weekend with great success. Again my
thanks.

Whilst using I realised that I can further automate the calculations,
so I attempted to do so using your formulas but with no success and was
wondering if you could take a look at the following for me.

When a match is played the following is recorded.
A1
points for
A2
points against
A3
Won
A4
drawn
A5
lost

If A1 is greater than A2, A3 should be assigned a "1"
If A2 is greater than A1, A5 should be assigned a "1"
If A1 is equal to A2, A4 should be assigned a "1"

It seemed to me that I should be able to figure out the above formulas
on the basis of the calculations you supplied but I was getting stuck
on the "<=" area.

Any help is appreciated.

Thanks


--
shaunl
------------------------------------------------------------------------
shaunl's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=25140
View this thread: http://www.excelforum.com/showthread.php?threadid=527886

.

Quantcast