Thread: Football score
View Single Post
  #4   Report Post  
wickedchew wickedchew is offline
Senior Member
 
Location: Philippines
Posts: 161
Default

Quote:
Originally Posted by gundesvan View Post
The problem is when i havent filled in the result yet, so when its empty its also the same and it print 2.

It got to be something like =IF(B4=B5and1;2,0)

?
=IF(AND(B4=0,B5=0),0,IF(B4=B5,2,0))
__________________
Asobi Wa Owari Da