Thread: Football score
View Single Post
  #3   Report Post  
gundesvan gundesvan is offline
Junior Member
 
Posts: 15
Default

Quote:
Originally Posted by wickedchew View Post
=IF(B4=B5,2,0)

That is if I understood your question.
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)

?

Now i got

=IF(B3C3; "3"; IF(B3<C3; "0"; IF(B3=C3; "2")))

but it need the last if to be bigger than one or else its 0