错误:IFS 期望位置 0 之后的所有参数成对出现

Question

我正在尝试根据 A2 的值引用单元格，但是当我使用以下代码时，我收到 #N/A 错误。我的谷歌不是英文的，所以我不知道确切的翻译，但这是关于 IFS 函数希望位置 0 之后的所有参数成对出现的东西。

这就是代码当前的样子。

=IFS(
$A2="[Greater Flask of the Vast Horizon]"; G2;
$A2="[Greater Flask of the Undertow]"; G3;
$A2="[Greater Flask of Endless Fathoms]"; G4;
$A2="[Greater Flask of the Currents]"; G5;
$A2="[Potion of Empowered Proximity]"; G6;
$A2="[Potion of Focused Resolve]"; G7;
$A2="[Superior Battle Potion of Intellect]"; G8;
$A2="[Superior Battle Potion of Agility]"; G9;
$A2="[Superior Battle Potion of Strength]"; G10;
$A2="[Superior Battle Potion of Stamina]"; G11;
$A2="[Potion of Unbridled Fury]"; G12;
$A2="[Superior Steelskin Potion]"; G13;
$A2="[Potion of Wild Mending]"; G14;
$A2="[Abyssal Healing Potion]"; G15;
)

我应该更改什么才能使其按预期工作？

Answer 1

删除G15后的逗号/分号：

=IFS(
$A2="[Greater Flask of the Vast Horizon]";   G2;
$A2="[Greater Flask of the Undertow]";       G3;
$A2="[Greater Flask of Endless Fathoms]";    G4;
$A2="[Greater Flask of the Currents]";       G5;
$A2="[Potion of Empowered Proximity]";       G6;
$A2="[Potion of Focused Resolve]";           G7;
$A2="[Superior Battle Potion of Intellect]"; G8;
$A2="[Superior Battle Potion of Agility]";   G9;
$A2="[Superior Battle Potion of Strength]";  G10;
$A2="[Superior Battle Potion of Stamina]";   G11;
$A2="[Potion of Unbridled Fury]";            G12;
$A2="[Superior Steelskin Potion]";           G13;
$A2="[Potion of Wild Mending]";              G14;
$A2="[Abyssal Healing Potion]";              G15)