I want to make a tournament table and I need to: make A1 cell type amount of points based on score (B1 is player 1 score, C1 is player 2 score)

I want it to automatically detect wins, draws and loses and base on it to give the correct amount of points (3, 1, 0).

1 Answer 1


You could calculate player 1 score with:


see this test sheet


  • Okay that works fine but nbot at my sheet, i guess i am jsut too stupid for this. Can you tell my how to copy that so it may work?
    – user293763
    Apr 6, 2022 at 11:09
  • i found out how to do it, thank you!
    – user293763
    Apr 6, 2022 at 12:22

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.