英文:
Sheets formula for sports predictor scores
问题
我正在创建一个Google表格来跟踪一场朋友小组的预测竞赛。
该竞赛涉及挑选每轮体育赛事的获胜者。玩家将在自行车赛每轮中挑选一个名字（来自固定的名单）。如果该自行车手赢得该轮比赛，玩家将获得20分。然而，如果自行车手获得第二名，玩家将获得10分，如果自行车手获得第三名，玩家将获得5分。
我已经有了一个公式，用于在结果出现并且自行车手处于第一、第二和第三名位置时，以及玩家已经选择了他们的预测时计算分数。然而，如果某轮比赛尚无结果，玩家尚未进行预测，该公式将会给玩家20分，因为玩家的预测是一个空单元格，与第一名自行车手的值相匹配 - 一个空单元格。
我已经包含了表格和公式的屏幕截图。
如何使玩家在A9:A11中没有自行车手时分数为零（C9:C11）？
英文:
I'm creating a Google sheet to keep track of a predictor competition for a group of friends.
The competition involves picking the winner for each round of a sporting event. Player will pick one name (from a fixed list of names) for each round of an cycling event. If this cyclist wins that round, players will gain 20 points. However, if the cyclist comes 2nd the player gets 10 points and if the cyclist comes 3rd the player gets 5 points.
I have the formula for when the results are in and there are cyclists in 1st, 2nd and 3rd positions and a player has selected their prediction. However, the formula is awarding the player 20 points when there are no results for a round yet and the player hasn't made a prediction. This is because the player's prediction is an empty cell which matches the value for the cyclist in 1st place - an empty cell.
I have included a screenshot of the spreadsheet and formula.
How can I have the player's score zero (C9:C11) when there are no cyclists in A9:A11?
答案1
得分: 1
=ifs(B8="",0,B8=A9,20,B8=A10,10,B8=A11,5,1,0)
英文:
<!-- language-all: js -->
You may try this in the merged section of C8:C11:
=ifs(B8="",0,B8=A9,20,B8=A10,10,B8=A11,5,1,0)
通过集体智慧和协作来改善编程学习和解决问题的方式。致力于成为全球开发者共同参与的知识库，让每个人都能够通过互相帮助和分享经验来进步。
评论