excel電子公式顯示引用了無(wú)效的函數(shù)名稱？

公式修改為(將公式中的漢字兩側(cè)加上半角單引號(hào))

=IF(AND(ISBLANK(Q4),ISBLANK(S4)),"未售",IF(AND(NOT(ISBLANK(Q4)),ISBLANK(S4)),"已售未收","已收房"))

或

=IF(AND(Q4="",S4=""),"未售",IF(AND(Q4"",S4=""),"已售未收","已收房"))