need a formula which calculates points for a predictions league

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

we are running a predictions league for the world cup where for a correct
score you get 3 points and for a correct result you get 1 point. how can this
be done so there is the least amount of manual work?
 
It sounds like you need to make use of the IF statement to do the
comparison

e.g = if (and(A1 = B1,A2 = B2),3,0)

for getting a correct score.
 
Back
Top