条件函数if怎么用（条件函数）
导读 姓名季度1季度2季度3表现张1408090普通员工 公式：=if(countif(B2:D2,">85")>2,"优秀员工",if(countif(B2:D2,">85")>1,"上进员工",i...
姓名季度1季度2季度3表现张1408090普通员工 公式：=if(countif(B2:D2,">85")>2,"优秀员工",if(countif(B2:D2,">85")>1,"上进员工",if(countif(B2:D2,">85")>0,"普通员工","工作待定")))张2908896优秀员工张3205030工作待定公式：=if(countif(B2:D2,">85")>2,"优秀员工",if(countif(B2:D2,">85")>1,"上进员工",if(countif(B2:D2,">85")>0,"普通员工","工作待定")))。
免责声明：本文由用户上传，如有侵权请联系删除！
