[Fuctifano]

First up,I'll admit that I'm pretty clueless when it comes to this sort of things; basic spreadsheets with totals are about my limit

But I'm working on this wee idea, and what I need is something that can convert football results into a running total of points.

What I'm doing at the moment is putting goals scored in column C, goals against in column D, and points gained in column E till I get the formula worked out. Unfortunately the IF command only has two posible outcomes as far as I'm aware. So what I have is:

=IF(C2>D2,3,0)

which obviously doesn't cover a draw. So to get to the point , how do I get a formula to cover all three outcomes the way I'm doing it.

Or is there a better way?

All help appreciated as the help package itself is of hee-haw use to me.

[Mr X]

Probably a better way, but if you wanna stick with what you know try nesting the IF statements.

eg

=IF(C2>D2,3,IF(c2=d2,1,0))

Should do the trick. What your doing is checking for a win first, if its not a win you then do a second check (or IF) to see if it was a draw. If that is also false then it must have been a loss. You can keep nesting IFs all day if you want. I once wrote a formula that had about 20odd permetations all checked by IFs!! Messy, but it worked

This post has been edited by andycqos: 11 November 2004 - 09:53

[Fuctifano]

Spot-on. Cheers.