https://youtube.com/watch?v=mX0-BlsDVRUWhy You Should Use Excel IFS Function - Don't Use Nested IF Excel IFS Formula is Alternatives to nested IF which is new function and still available in office 365…