If & andif

[cable]

I have 3 sheets on a spreadsheet. I want to compare values across the board and display the results.
It is for scores:

An example of what I am looking for is: 1=home win & 2=away win 3=loss 4=draw
if A1=1 (a prediction),
and b1 > c1 (ie scores mean a win)
And
then d1 = 1 (a win),
and E1 = 10 (Points scored)

Any Ideas?

 

[Chris Davison]

On 2002-02-28 09:01, cable wrote:
I have 3 sheets on a spreadsheet. I want to compare values across the board and display the results.
It is for scores:

An example of what I am looking for is: 1=home win & 2=away win 3=loss 4=draw
if A1=1 (a prediction),
and b1 > c1 (ie scores mean a win)
And
then d1 = 1 (a win),
and E1 = 10 (Points scored)

Any Ideas?

Hey Cable,

which sport awards 10 points for a win ?

Anyhows, that aside, I designed a league for the current English soccer Premiership including known results and predictions but I really can't follow your example.....

wanna send me the file with an explanation of what you're trying to achieve ? I'll take a look at it

novulari@hotmail.com