Re: Sports Comp Ladder tabulating help needed

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance


Hi Pete,
I used the spreadsheet 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

.

Relevant Pages

  • Re: Slowly MAXIMA in TeXmacs
    ... Alfie wrote: ... You can find wxMaxima here: http://wxmaxima.sourceforge.net/ ... and I wish you success with your calculations. ...
    (sci.math.symbolic)
  • Re: "I wonder if she lets anyone into that island of light?"
    ... cryptoguy wrote: ... If you 'do these kinds of calculations', then by definition, they ... chance of success, I'd never do *anything*!" ... Elan, Order of the Stick ...
    (rec.arts.sf.written)
  • Re: Lake water level modelling
    ... Its basically simple water balance calculations. ... If it doesn't, you either miss some of the inputs, some of the outputs or miscalculate your change in storage, there is NO OTHER MAGIC. ... simple spreadsheet model. ... the most stupid thing is that counting such parameters like ...
    (sci.geo.hydrology)
  • Re: Joining threads; why?
    ... fashion, but why not create three threads: one to attach to SQL, one to open ... the spreadsheet, and one to access the web site. ... calculations, still a background operation, requires all three datasets. ... you join threads and do not proceed until all three have delivered data. ...
    (microsoft.public.dotnet.languages.csharp)
  • Re: What are the benefits of using VB for excel formulas?
    ... I accept that if you import a spreadsheet into Access (because it has got ... calculations speed in VB except if you can get to the same result with fewer ... For information on large Excel workbooks and optimising calculation speed I ... The problem with SQL-type database calculations is that it is very hard work ...
    (microsoft.public.excel.programming)