Automatically calculating...

  • Thread starter Thread starter andy
  • Start date Start date
A

andy

Hi,
Im trying to make a spreadsheet calculate Columns to show
difference (in the context of points gained and points
lost), a column that shows league points (2 if the team
wins, 1 if they draw, and none if they loose), as well as
a column that will show a comment saying whether the team
has won lost or drawn.
Thanking you in advance,
Andy
 
Andy
A B C D E F
Home Away H Goals A Goals Points Comment
Lpool Arsenal 2 2 1 Draw

Formula for column E
=IF(C16>D16,2,IF(C16<D16,0,1))
Formula for column F
=IF(E16=2,"Win",IF(E16=1,"Draw","Lost"))

Regards
Peter
 
You must log in or register to reply here.

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

league tables 1
Excel Handicap Formula 0
League table 3
Automatically put rows containing a number in numerical order 1
Excel Excel conundrum - I've tried and tried, but 10
Add value as changes 4
Automatic sort macro 2
League Table - VLOOKUP 2

Back
Top