|B2 is where player1's points scored are entered. H2 player 2's.|
I want D2 and F2 to display a 1 or 0 for the frame score.
I'm not sure what you are doing with D2 and F2 and how they relate to B2 and H2.
To display a 1 if B2 is greater than H2, a simple IF statement will work:
To check if H2 is greater than B2, simply reverse it:
Does that get you any closer to your goal?
BTW...what happens if B2 = H2?
Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.