Nesting

Input: Sample file with base data.

Download sample input files here

Goal: Setup a workbook formula that pulls the data from the sample file and apply a filter to get all the entries which does not belong to the company name "LLOYD ELECTRIC & ENGINEERING" with interest rate greater than 7 or date less than 01-01-2020.