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
 
Back
Top