若A1或B1或C1或D1等于“我”,则E1=我,用公式则呢么表达
来源:学生作业帮助网 编辑:作业帮 时间:2024/07/02 12:02:57
![若A1或B1或C1或D1等于“我”,则E1=我,用公式则呢么表达](/uploads/image/z/2662797-21-7.jpg?t=%E8%8B%A5A1%E6%88%96B1%E6%88%96C1%E6%88%96D1%E7%AD%89%E4%BA%8E%E2%80%9C%E6%88%91%E2%80%9D%2C%E5%88%99E1%3D%E6%88%91%2C%E7%94%A8%E5%85%AC%E5%BC%8F%E5%88%99%E5%91%A2%E4%B9%88%E8%A1%A8%E8%BE%BE)
若A1或B1或C1或D1等于“我”,则E1=我,用公式则呢么表达
若A1或B1或C1或D1等于“我”,则E1=我,用公式则呢么表达
若A1或B1或C1或D1等于“我”,则E1=我,用公式则呢么表达
在E1单元格输入如下公式:
=IF(OR(A1="我",B1="我",C1="我",D1="我"),"我","")
若A1或B1或C1或D1等于“我”,则E1=我,否则不显示.