Learn to create a NESTED IF, adding in the AND formula from scratch. To better follow this lesson you need to already know how to use the IF, 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.