☰

无法在复杂的 IF 公式中发现错误

tag-icon • tag-icon microsoft-excel-2010
无法在复杂的 IF 公式中发现错误

Excel 此公式中有错误，但我找不到它。

=IF(AM8="Pass",(IF(SUM(AN8:AO8)=3,"Excellent performance. Keep it up.",IF(AND(FL8<>"",SUM(AS8:AU8)=0),"Excellent performance in "&FL8&" but can still improve in other subjects.",if(gs8<>"","Must work harder in " &gs8&" and aim higher next term.",if(sum(Ap8:AQ8)=3,"Good effort. Keep improving",if(sum(AR8:AS8)=3,"Just managed to pass. Need to focus on weak areas."))))),"Satisfactory performance. Overall improvement required"),if(and(BD8=true,sum(AN8:AR8)=3),"Passed in Main subjects. Must work harder in GP", "Very poor performance. Must work very hard."))

任何有助于修正此公式的帮助以及有关更好地完成此任务的任何建议都将受到高度赞赏。

答案1

尝试这个：

=IF(AM8="Pass",(IF(SUM(AN8:AO8)=3,"Excellent performance. Keep it up.",IF(AND(FL8<>"",SUM(AS8:AU8)=0),"Excellent performance in "&FL8&" but can still improve in other subjects.",IF(GS8<>"","Must work harder in " &GS8&" and aim higher next term.",IF(SUM(AP8:AQ8)=3,"Good effort. Keep improving",IF(SUM(AR8:AS8)=3,"Just managed to pass. Need to focus on weak areas.","Satisfactory performance. Overall improvement required")))))),IF(AND(BD8=TRUE,SUM(AN8:AR8)=3),"Passed in Main subjects. Must work harder in GP", "Very poor performance. Must work very hard."))

`if(sum(AR8:AS8)=3,"勉强及格。需要重点关注薄弱环节。")))),"表现令人满意。需要全面提高"),if(and(BD8=true,sum(AN8:AR8)=3),"主要科目及格。必须在 GP 上更加努力", "表现非常差。必须非常努力。"))'

这是出现错误的部分：您关闭了 5 个 if，并为 Value if False 写入了 2 个值，我已更改它并修复了公式，只需对其进行测试。

答案2

我认为与这部分有关：

"表现令人满意。需要全面提高"),if(and(BD8=true,sum(AN8:AR8)=3),"主要科目及格。必须在 GP 上更加努力", "表现非常差。必须非常努力。"))

我认为它可能需要在它前面加一个 IF(，但我没有太多时间去彻底检查它。

相关内容