2, 使用if函数,总分大于等于270的总评为优秀,总分大于等于180的总评为合格,其余的总评为不合格

Question

如题所述

Answer 1

=if(A1<270, if(A1<180,"不合格", "合格"), "优秀")

Answer 2

#include<stdio.h>
int main()
{
int Chinese,Math,English,sum;
printf("\nplease input your score :\nChinese English Math\n");
scanf("%d",&Chinese);
printf(" ");
scanf("%d",&English);
printf(" ");
scanf("%d",&Math);
if((sum=Chinese+Math+English)>=270)
printf("\nYour grade is A\n");
else if((sum=Chinese+Math+English)>=180)
printf("\nYour grade is B\n");
else printf("\nyour grade is C ,Your didn't pass the examination\n");
return 0;
}本回答被网友采纳

Answer 3

请问这个是Excel的么？追问

对，答应女友的，今晚不做出来不睡觉的

追答

例子：
以A1为输入分数，B2显示评级：
在B2里输入
=if(A1>270,"优秀",if(A1>180,"合格","不合格"))