这两个公式如何合并成一个公式?
来源:学生作业帮 编辑:灵鹊做题网作业帮 分类:综合作业 时间:2024/07/02 15:29:36
这两个公式如何合并成一个公式?
=IF((C3>=92)*(F3>=92)*(D3>=$J$8)*(H3="√"),"★","")
=IF(OR(COUNTIF(I3,"*"&{"迟到","早退","事假"}&"*")),"","★")当K3满足第一个公式且I3中不含有迟到,早退,事假时=★.当K3满足C3>=94,F3>=94,D3>=$J$9,H3="√"且I3中不含有迟到,早退,事假时=★★.
=IF((C3>=92)*(F3>=92)*(D3>=$J$8)*(H3="√"),"★","")
=IF(OR(COUNTIF(I3,"*"&{"迟到","早退","事假"}&"*")),"","★")当K3满足第一个公式且I3中不含有迟到,早退,事假时=★.当K3满足C3>=94,F3>=94,D3>=$J$9,H3="√"且I3中不含有迟到,早退,事假时=★★.
![这两个公式如何合并成一个公式?](/uploads/image/z/16227457-25-7.jpg?t=%E8%BF%99%E4%B8%A4%E4%B8%AA%E5%85%AC%E5%BC%8F%E5%A6%82%E4%BD%95%E5%90%88%E5%B9%B6%E6%88%90%E4%B8%80%E4%B8%AA%E5%85%AC%E5%BC%8F%3F)
K3单元格输入公式
=IF((H3"√")+OR(COUNTIF(I3,"*"&{"迟到","早退","事假"}&"*")),"",IF((C3>=94)*(F3>=94)*(D3>=$J$9),"★★",IF((C3>=92)*(F3>=92)*(D3>=$J$8),"★","")))
这样试一下
=IF((H3"√")+OR(COUNTIF(I3,"*"&{"迟到","早退","事假"}&"*")),"",IF((C3>=94)*(F3>=94)*(D3>=$J$9),"★★",IF((C3>=92)*(F3>=92)*(D3>=$J$8),"★","")))
这样试一下