Thanks:  0
Likes:  0

# Thread: If & andif

1. 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?

2. 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

## User Tag List

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts
•