0

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

0

You could calculate player 1 score with:

=arrayformula(ifs(B4:B="","",C4:C="","",B4:B<C4:C,0,B4:B=C4:C,1,B4:B>C4:C,3))

see this test sheet

scores

2
  • 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 at 11:09
  • i found out how to do it, thank you!
    – user293763
    Apr 6 at 12:22

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

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