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

Quote:
Originally Posted by gundesvan View Post
=if(B4+B5;equal and greater0;2;0)

It's a football diagram
So if the score is equal then show 2 point.
But the problem is that when i havent inserted any score yet 0 and 0 is also equal and it prints 2 point.. So it got to be equal and larger than 1 then print 2 or else 0

Any tips on how to fix?
=IF(B4=B5,2,0)

That is if I understood your question.
__________________
Asobi Wa Owari Da