How to use the IFS Ifna and emoji function in Excel 2019
IFS is a new function, available in Office 365 and Excel 2019. Use the IFS function to test multiple conditions and return a value corresponding to the first TRUE result. Unlike the IF function, The IFS function can test multiple conditions at the same time without nesting multiple IF statements. Formulas based on IFS are therefore shorter and easier to read and write.