14
In cell F12, use the AND function nested in an IF
3
function to determine if the student has a permission slip
and a uniform. If the student has a permission slip and
the uniform size is not blank (<>""), then display
Yes in
the field; otherwise, display No . Copy the formula in F12
down to F17.
15
In cell F18, use the COUNTIF function to determine how
many students are currently traveling to the competition
as indicated by Yes in cell range
F12:F17
.
3