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

Monitor product movement using IFS function | Excel Basics