ifs函数是 Excel 2016的新增函数，可以取代多个if语句的嵌套，简直就是if函数的开挂版本。 有了ifs函数，在写多个条件嵌套的函数时就简单多了。

Added by Microsoft in 2016, the IFS function replaces the need for multiple nested IF statements. You can put all your conditions (percentage grade cutoffs in this example) in one function, making it ...