Solved works spreadsheet. Trouble entering snooker results.

July 15, 2013 at 11:36:24
Specs: Windows 7
I am making a spreadsheet for our county's snooker team. all went well with regards to relevant formulas for total number of points scored, highest break. However i cant seem to get it to compare
two sets of numbers, i.e. player 1's points per frame and player 2's points per frame. As i want it to read these two data entries and display a 1 for the highest score, and i 0 for the lowest. Please help.

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.


See More: works spreadsheet. Trouble entering snooker results.

Report •

#1
July 15, 2013 at 11:58:13
✔ Best Answer
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:

=IF(B2>H2,1,0)

To check if H2 is greater than B2, simply reverse it:

=IF(H2>B2,1,0)

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.


Report •
Related Solutions


Ask Question