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.


--
mrice

Research Scientist with many years of spreadsheet development experience
------------------------------------------------------------------------
mrice's Profile: http://www.excelforum.com/member.php...o&userid=10931
View this thread: http://www.excelforum.com/showthread...hreadid=545780