Overidding IF function

[denv]

I am making a table for a competition. So far I have it sorted out so
that from each match it can decide who is the winner and loser or if it
is a draw. What I want to find out is when it puts draw as the result,
it keeps the winner and loser so for instance if x played y and the
score was 10-10 it would put DRAW and give both teams two points on the
table, but it still thinks one of them is a winner so it gives one of
them 4 points as well. How do I make a formula that says if it is a
draw the both the winner and loser cells are nullified?
Please Help me

 

[Bob Phillips]

Denv,

It should be as simple as
=IF(A1>A2,action1,IF(A1<A2,action2,action3))

but I think it may be more complex, so post your examples in plain text.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

 

[Peo Sjoblom]

How do you enter the results, in the same cell formatted as text (else 10-10
will return Oct 10)?
Or do you use 2 different cells. regardless what formula are you using for
win/loss?
Assume you are using 2 cell, home team cell is A1, away team is B2, in the
cell of the home team put

=IF(A1>B1,3,IF(AND(ISNUMBER(A1),A1=B1),2,0))

Just reverse the order for the away team

=IF(B1>A1,3,IF(AND(ISNUMBER(A1),A1=B1),2,0))

if you are using the same cell for the result the home team (points in the
left part of the cell)
could look like

=IF(LEFT(A1,FIND("-",A1)-1)+0>MID(A1,FIND("-",A1)+1,255)+0,3,IF(LEFT(A1,FIND
("-",A1)-1)+0=MID(A1,FIND("-",A1)+1,255)+0,2,0))