Excel 2007 : excel equal function problems

Hi Guys hope this is right place to post, anyway here goes my problem

i am designing my own football table for our group now I had some problems with vlookup clashes (same rank error) i solved that but now i have another prob as you football fans will know if you draw you get 1 point now im using this formula

=IF('Group Stages'!B5='Group Stages'!C5,1,0)

now of course 2 blank cells means technically they are equal so i get the result 1 now if i wrote in numbers that were the same then that would be fine but of course if they are blank its because they havent played, so how can i resolve this problem is there a better formula to use please help asap guys

p.s. any more info to help let me know

CHEERS Liam

Originally Posted by DonkeyOte

Perhaps:

=IF(AND('Group Stages'!B5='Group Stages'!C5,'Group Stages'!B5<>""),1,0)

this seems to work atm.... will post if any problems thank you but just wondering could you explain what its doing???

Hi,
maybe have a look at XL's help. It's all explained there