Problem with IF formulae!!!

Hi, I am trying to formulate an if statement to look at the results from a series of Football results, 20 in total. The Home Team's score is in D2, E2 etc while the away Teams score is in D3, E3, I have the following formula, =+IF(D2>D3,2,+IF(D2=D3,1,0)) which works fine where results are entered, for example 1-0, 0-1 or 0-0 or any combination of win, lose or draw. The problem I have is that cells without results return a score of 1 as it sees 2 unpopulated cells as draw.

Grateful for any idea's.

Cheers

tallpaul

try something like

=IF(D2>D3,2)+IF(AND(D2=0,D3=0),0,IF(D2=D3,1,0))

R

i am assuming that if you do not put results in the cell will be empty

if so try this

=IF(AND(D2="",D3=""),"",IF(D2>D3,2,IF(D2=D3,1,0)))

note what happens for an away win

steve

Originally Posted by stevekirk

i am assuming that if you do not put results in the cell will be empty

if so try this

=IF(AND(D2="",D3=""),"",IF(D2>D3,2,IF(D2=D3,1,0)))

note what happens for an away win

steve

Hi Steve, thanks for your solution, it worked fine for one result, but I couldn't de-bug it for 20 different scenario's, probably down to my lack of knowledge??
Thanks for your help

tallchap

Originally Posted by Ruthki

try something like

=IF(D2>D3,2)+IF(AND(D2=0,D3=0),0,IF(D2=D3,1,0))

R

Hi Ruthki, this worked perfectly, once doctored to suit results over 20 different Cell selections.

Thanks for your help.

tallchap