新点的Excel可以用 =IFS function 解决这个问题，干净得多。。。

https://support.microsoft.com/en-us/office/ifs-function-36329a26-37b2-467c-972b-4a39bd951d45

https://www.ablebits.com/office-addins-blog/excel-ifs-function/#:~:text=The%20Excel%20team%20has%20recently,Excel%202021%20and%20Excel%202019.