Tournament table Google Sheets

Question

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).

Answer 1

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