Learn to create an IFS with AND formula from scratch. This is an alternative and simpler method to the NESTED IF formula.

To better follow this lesson you need to already know how to use the AND formula and cell referencing.

To further assist with the tutorial,  a practice workbook is also provided for all to follow along as we at ESS believe that you learn by doing.