问题描述：
EXCEL中的IF公式
我有一个EXCEL问题需要用公式表达出来,该怎么写呢?
若BS列为空,则结果为空；若BR列为VIRUS,结果为符合；若BT列为空,则结果也为空；若BY列为"YES CLOSED",则为符合；否则为不符合
写出来是这样的正确吗?if(bs=" "," ",if(br="virus","符合",fi(bt=" "," ",if(by="yes closed","符合","不符合"
最后面补充四个括号)吧,呵呵
我有一个EXCEL问题需要用公式表达出来,该怎么写呢?
若BS列为空,则结果为空；若BR列为VIRUS,结果为符合；若BT列为空,则结果也为空；若BY列为"YES CLOSED",则为符合；否则为不符合
写出来是这样的正确吗?if(bs=" "," ",if(br="virus","符合",fi(bt=" "," ",if(by="yes closed","符合","不符合"
最后面补充四个括号)吧,呵呵
问题解答：
我来补答展开全文阅读