Excel表格中if函数用于计算大学生体能测试单杠的成绩，需要根据年龄和拉单杠的数量计算分数。谢谢

计算大学生体能测试单杠的成绩，假设单杠的成绩在A18,年龄在B18，C18为分数，具体公式如下：

C18:

=IF(A18>=MAX(INDIRECT(LOOKUP(B18,{0,25,28,31,34,37,40},{"B3:B12","C3:C12","D3:D12","E3:E12","F3:F12","G3:G12",""}))),100,IFERROR(INDEX($A$3:$A$12,MATCH(A18,INDIRECT(LOOKUP(B18,{0,25,28,31,34,37,40},{"B3:B12","C3:C12","D3:D12","E3:E12","F3:F12","G3:G12",""})),-1)+IF(COUNTIF(INDIRECT(LOOKUP(B18,{0,25,28,31,34,37,40},{"B3:B12","C3:C12","D3:D12","E3:E12","F3:F12","G3:G12",""})),A18)=0,1,0)),"不合格"))

图片数据不太模糊，数据仅是模拟

如有帮助，望采纳。

有没有文件提供下，你这图片没法看，了解清楚情况才能对症下药