Hi guys, im trying to set up a scoring spreadsheet for the world cup
(not an interest of mine but all in a days work!) im having problems
with one of the formulas..

If the scores for a match are say 3 & 2 and somebody guesses the score
at being 4 & 2, I want to enter a formula for it to recognise the
winner and award 1 point..

so far I have the following =IF(C7+G7='Winning Scores'!B5+'Winning
Scores'!D5,"3","0") to work out the points for getting the exact score
but what I can't work out is what formula to put in to recognise the
winning team..

workbook 1
C7 G7
3 2

workbook 2
C7 G7
4 2

please help!

nx


--
n1kk1
------------------------------------------------------------------------
n1kk1's Profile: http://www.excelforum.com/member.php...o&userid=35173
View this thread: http://www.excelforum.com/showthread...hreadid=549954