We have discussed about Nested_IF and #SWITCH_Functionin in previous video, Now we are going to know about one more logical function that is #IFS_Function and its work like IF and SWITCH, but much better than both functions. IFS is a new function, available in Office 365 and Excel 2019. The IFS function 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

4.2K views · 53 reactions | How to use IFS function in Excel to assign grades. #exceltips #excel #exceltutorial #reelsfyp | Excel Basics | Facebook