Football Scores

[rmtaylor]

Can anyone help with a fromula for the following.

Formula to return a value when a wining result is predicted

E.g. predicted results =Cell C2=4 cell D2=2
(a score of 4 2)

Actual results =Cell E2=1 Cell F2 = 0
(a actual score of 1 0)

Formula in Cell G2 would return a given value say “correct” to denote the prediction of a winning score as correct.

Thanks in advance
Robert


[ This Message was edited by: rmtaylor on 2002-05-18 05:55 ]

[Nimrod]

=IF(AND(C2=E2,D2=F2),"Correct","Wrong")

[rmtaylor]

On 2002-05-18 02:36, Nimrod wrote:
=IF(AND(C2=E2,D2=F2),"Correct","Wrong")

Hi
Thanks for the reply but I already have that part working.
I was attempting to take it a stage further to get the formula to give a value "correct" for prediction of the correct result not just the score i.e. a win of any score predicted would return "correct"
e.g. prediction four two
Result one nil would be correct as a win for the home team was predicted and so on.

Not that I will be recording any Scottish results

[Chris Davison]

Robert,

would you like to take a look at my prediction league for the world cup ?

it might get you started.... I was asking those very same questions about 3 weeks ago

Chris

~
~
~

[Ian Mac]

what about:

=IF(VLOOKUP(C2-D2,{-10,1;0,2;1,3},2)=VLOOKUP(E2-F2,{-10,1;0,2;1,3},2),"Correct","Incorrect")

?

[Ian Mac]

Dave your post disappeared!!
_________________
Share the wealth!!
Ian Mac

[ This Message was edited by: Ian Mac on 2002-05-18 11:28 ]

[Dave Patton]

=IF(AND(C2=E2,D2=F2),"Correct",IF(AND(C2>D2,E2>F2),"Win","No"))

correct wording and references as necessary

[Ian Mac]

On 2002-05-18 11:30, Dave Patton wrote:

=IF(AND(C2=E2,D2=F2),"Correct",IF(AND(C2>D2,E2>F2),"Win","No"))

correct wording and references as necessary

Dave, I don't think the score matter for this probem, I believe Robert want to know whether both scores are Wins, Draws or Losses

[Jack in the UK]

Chris please sent to work if different to what i have already.

Cheers mate!