excel - J8空白时需要帮助保持单元格空白

Question

J8空白时需要帮助保持单元格空白

=IF(J8="完成","通过",IF(J8="进行中","未完成","NA"))

标签： excelif-statement

Answer 1

如果您更新了 Excel 2019 / 365

使用IFS功能

=IFS(J8="Complete","Pass",J8="In-Process","Incomplete",J8="","",TRUE,"NA")