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

Hi

Try this:
=IF(OR(AND(C7<G7,'Winning Scores'!B5<'Winning Scores'!D5),AND(C7G7,'Winning
Scores'!B5'Winning Scores'!D5)),3,0)

Hope this helps.
Andy.


"n1kk1" wrote in
message ...

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

"n1kk1" wrote in
message ...

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

Try =(AND((C7G7)=('workbook 2'!C7'workbook 2'!G7),(C7<G7)=('workbook
2'!C7<'workbook 2'!G7)))

Note that in your other formula you've checked for the total score, not the
exact score, so you'd give 3 points for a 5 & 2 score if the prediction had
been 4 & 3.
Note also that you've written a text value of 3 as your output, not a
number, so you wouldn't be able to add up the points.
--
David Biddulph