EXCEL中的IF公式我有一个EXCEL问题需要用公式表达出来,该怎么写呢?若BS列为空,则结果为空;若BR列为VIRUS,结果为符合;若BT列为空,则结果也为空;若BY列为"YES CLOSED",则为符合;否则为不符合写
来源:学生作业帮助网 编辑:作业帮 时间:2024/09/09 21:40:13
![EXCEL中的IF公式我有一个EXCEL问题需要用公式表达出来,该怎么写呢?若BS列为空,则结果为空;若BR列为VIRUS,结果为符合;若BT列为空,则结果也为空;若BY列为](/uploads/image/z/669754-10-4.jpg?t=EXCEL%E4%B8%AD%E7%9A%84IF%E5%85%AC%E5%BC%8F%E6%88%91%E6%9C%89%E4%B8%80%E4%B8%AAEXCEL%E9%97%AE%E9%A2%98%E9%9C%80%E8%A6%81%E7%94%A8%E5%85%AC%E5%BC%8F%E8%A1%A8%E8%BE%BE%E5%87%BA%E6%9D%A5%2C%E8%AF%A5%E6%80%8E%E4%B9%88%E5%86%99%E5%91%A2%3F%E8%8B%A5BS%E5%88%97%E4%B8%BA%E7%A9%BA%2C%E5%88%99%E7%BB%93%E6%9E%9C%E4%B8%BA%E7%A9%BA%EF%BC%9B%E8%8B%A5BR%E5%88%97%E4%B8%BAVIRUS%2C%E7%BB%93%E6%9E%9C%E4%B8%BA%E7%AC%A6%E5%90%88%EF%BC%9B%E8%8B%A5BT%E5%88%97%E4%B8%BA%E7%A9%BA%2C%E5%88%99%E7%BB%93%E6%9E%9C%E4%B9%9F%E4%B8%BA%E7%A9%BA%EF%BC%9B%E8%8B%A5BY%E5%88%97%E4%B8%BA%22YES+CLOSED%22%2C%E5%88%99%E4%B8%BA%E7%AC%A6%E5%90%88%EF%BC%9B%E5%90%A6%E5%88%99%E4%B8%BA%E4%B8%8D%E7%AC%A6%E5%90%88%E5%86%99)
xoK@ʸG|f ȇY
BllABIҘYQ8MnۣB]{w}>w\>Gb1nNG
VX0
4m6t:uGuݣ.ݳst>-#esvvI HzB4+|}t
qj؊7"U$VeLb 6p͋QHR4.HR=x9ץ۱w \o
|?&