当J8空白时需要帮助保持单元格空白
=如果(J8 ="Complete","Pass",如果(J8 ="In-Process","Incomplete","NA"))
再嵌套一层if:=如果(J8 =",",your_original_if)
如果你有Excel 2019/365更新
使用IFS函数
=IFS(J8="Complete","Pass",J8="In-Process","Incomplete",J8="","",TRUE,"NA")