如果想要对考试成绩进行分级:优秀:>90;良好:>80,合格:>60,不及格:<60,则以下公式正确的是()。
选项:
A:=IF(A1<60,"不及格",if(A1<80,"合格",if(A1<=90,"良好","优秀")))
B:=IF(A1<60,"不及格",if(A1<=80,"合格",if(A1<90,"良好","优秀")))
C:=IF(A1>90,"优秀",if(A1<60,"不及格",if(A1>80,"良好","合格")))
D:=IF(A1>90,"优秀",if(A1<60,"不及格",if(A1=>80,"良好","合格")))
发布时间:2024-06-12 20:35:04