Another Excel Question (IF Function)

[Swordfish]

Hoping for a bit of help here.

I have a spreadsheet (team results) and need to enter a column of points won in a match. Each match contists of 12 games so I have a column for games won and games lost. What I need is the folurmlea that will give 3 points if the games won is greater than games lost, 1 point if they are equal or 0 is won is less than lost.

So what I need is this

=IF(gameswon>gameslost,pts=3,or IF gameswon=gameslost,pts=-1,else,0)

If that makes sense. I can do the If function with only two outcomes but cant seem to get my head around 3 outcomes.

Cheers

G

 

[Swordfish]

Update

I have been trying this nested function (B3 is matches won and C3 is matches lost)

=IF(B3=C3,1,IF(B3>C3,3)),0

seems logical to me but then I have had no coffee this morning so far date

Have been trying this nested function (B3 is matches won and C3 is matches lost)

=IF(B3=C3,1,IF(B3>C3,3)),0

seems logical to me but then I have had no coffee this morning so far

 

[Swordfish]

Got it fixed !

 

[Swordfish]

If it was for badminton I could have let you have my spreadsheets.
What started out a simple way of tracking match results has grown into a monster that tracks and generates stats for matches, individual players, pairs, etc.
I have five divisions to manage and each sheet is abot 1MB in size now. I'm using LO, but I think I'll be switching back to Excel as I find it easier to program macros.

It's for the pool league I run

I usually update the table every week and did a random check only to find I was 2 frames out. Managed to find it though using the IF function and re-entering all results .

Next year I think I'm gonna go for a dynamic site !!