IF Function

M

Michael

Hi I will explain what I am trying to do.Two columns of football scores in
A1 and B1 they could be 0-0 1-1 1-0 0-1 etc I am trying to use the IF
statement to work out if they are say draw, score draw, home win, away win.
I am getting nowhere can you help please
Michael
 
F

Franz Verga

Michael said:
Hi I will explain what I am trying to do.Two columns of football
scores in A1 and B1 they could be 0-0 1-1 1-0 0-1 etc I am trying to
use the IF statement to work out if they are say draw, score draw,
home win, away win. I am getting nowhere can you help please
Michael
Click to expand...

Hi Michael,

in column C, in C2 (I assume that in row 1 you have column headers) type
this formula:

=IF(AND(A2=0,B2=0),"draw",IF(A2=B2,"score draw",IF(A2>B2,"home win","away
win")))

Now you have to drag across the rows...

--
Hope I helped you.

Thanks in advance for your feedback.

Ciao

Franz Verga from Italy
 
M

Michael

You certainly did, many thank.
I have a lot of football data and would love to be able to use excel for
showing league tables but don't even know where to start.. (loaded question)
Michael
 
T

Trevor Shuttleworth

One way:

=IF(AND(A1=B1,A1=0),"draw",IF(AND(A1=B1,A1<>0),"score draw",IF(A1>B1,"home
win","away win")))

Regards

Trevor
 
Top