如题所述
第1个回答 2012-02-13
如果三个数分别在A1、B1、C1,则在D1输入公式:
=IF(SUM(A1:C1)>=230,"一等",IF(SUM(A1:C1)>=180,"二等","")) 复制下拉即可
=IF(SUM(A1:C1)>=230,"一等",IF(SUM(A1:C1)>=180,"二等","")) 复制下拉即可
第2个回答 2012-02-13
假定三个数分别在A1、B1、C1单元格
=IF(A1+B1+C1>=230,"一等",IF(A1+B1+C1>=180,"二等",""))
或:
=LOOKUP(A1+B1+C1,{0,180,230;"","二等","一等"})
=IF(A1+B1+C1>=230,"一等",IF(A1+B1+C1>=180,"二等",""))
或:
=LOOKUP(A1+B1+C1,{0,180,230;"","二等","一等"})
第3个回答 2012-02-13
IF 函数
=IF(SUM(A10:C10)>=230, "一等", IF( SUM(A10:C10)>=180, "二等", "合格" ))本回答被网友采纳
=IF(SUM(A10:C10)>=230, "一等", IF( SUM(A10:C10)>=180, "二等", "合格" ))本回答被网友采纳