View Single Post
  #11   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Pete_UK
 
Posts: n/a
Default Sports Comp Ladder tabulating help needed

Try this in A5:

=IF(AND(ISNUMBER(A1),ISNUMBER(A2),A1=A2),1,0)

With this, both A1 and A2 have to be numbers as well as being equal, so
0 0 will count as a draw but 1 (or 2) blanks won't.

Hope this solves it - bed time now.

Pete