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."))
Будем весьма благодарны за любую помощь в исправлении этой формулы и любые предложения относительно лучшего способа решения этой задачи.