1.
求和: =SUM(K2:K56) ——对K2到K56这一区域进行求和;
平均数: =AVERAGE(K2:K56) ——对K2 K56这一区域求平均数;
3.
4.
等级: =IF(K2>=85,"优",IF(K2>=74,"良",IF(K2>=60,"及格","不及格")))
5.
=74,"良",IF(K2>"/> =74,"良",IF(K2>"/>
excel表格数学计算方法求高手给解答
1.
求和: =SUM(K2:K56) ——对K2到K56这一区域进行求和;
平均数: =AVERAGE(K2:K56) ——对K2 K56这一区域求平均数;
3.
4.
等级: =IF(K2>=85,"优",IF(K2>=74,"良",IF(K2>=60,"及格","不及格")))
5.