Then, I'll use Excel's AutoFill to copy the formulas to the remaining rows. Notice how each output is either TRUE or FALSE, depending on whether the conditions have been met. While this is handy ...

so use numbers if you want Excel to AutoFill the data for you. Referencing other cells in formulas is a great way to link ...