如题所述
第1个回答 2010-08-16
如果成绩是B2列到I2列可直接将下式粘贴到想要出现“优,良,中”的单元格的编辑栏中,
=IF(AVERAGE(B2:I2)>=90,"优",IF(AVERAGE(B2:I2)>=75,"良","中"))
若不是请将成绩的位置替换到下式中(B2:I2)的位置
如果成绩在C2到G2列,可将B2:I2改为C2:G2
注意式子中两个位置都要改
=IF(AVERAGE(B2:I2)>=90,"优",IF(AVERAGE(B2:I2)>=75,"良","中"))
若不是请将成绩的位置替换到下式中(B2:I2)的位置
如果成绩在C2到G2列,可将B2:I2改为C2:G2
注意式子中两个位置都要改
第2个回答 2010-08-11
IF(B8<75,"中",IF(B8<90,"良","优秀"))
公式:
姓名 分数 等级
张1 60 =IF(B3<75,"中",IF(B3<90,"良","优秀"))
张2 89 =IF(B4<75,"中",IF(B4<90,"良","优秀"))
张3 90 =IF(B5<75,"中",IF(B5<90,"良","优秀"))
张4 85 =IF(B6<75,"中",IF(B6<90,"良","优秀"))
张5 93 =IF(B7<75,"中",IF(B7<90,"良","优秀"))
张6 74.5 =IF(B8<75,"中",IF(B8<90,"良","优秀"))
计算结果:
姓名 分数 等级
张1 60 中
张2 89 良
张3 90 优秀
张4 85 良
张5 93 优秀
张6 74.5 中
公式:
姓名 分数 等级
张1 60 =IF(B3<75,"中",IF(B3<90,"良","优秀"))
张2 89 =IF(B4<75,"中",IF(B4<90,"良","优秀"))
张3 90 =IF(B5<75,"中",IF(B5<90,"良","优秀"))
张4 85 =IF(B6<75,"中",IF(B6<90,"良","优秀"))
张5 93 =IF(B7<75,"中",IF(B7<90,"良","优秀"))
张6 74.5 =IF(B8<75,"中",IF(B8<90,"良","优秀"))
计算结果:
姓名 分数 等级
张1 60 中
张2 89 良
张3 90 优秀
张4 85 良
张5 93 优秀
张6 74.5 中
第3个回答 2010-08-07
假设数据在A1中
(1)=LOOKUP(A1,{0,74,89},{"中","良好","优秀"})
(2)=IF(A1>89,"优秀",IF(A1>74,"良好","中"))本回答被网友采纳
(1)=LOOKUP(A1,{0,74,89},{"中","良好","优秀"})
(2)=IF(A1>89,"优秀",IF(A1>74,"良好","中"))本回答被网友采纳