I am building a spreadsheet to be used for assesments. I want a box
that will indicate whether the person is "eligible" or "ineligible." I
want this to be formula driven. So the user will select "meets,"
"exceeds," or "below" for several options. So for example the user
would need to select meets for cell A5, meets for cell A6, and exceeds
for cell A7 for the employee to eligible. If they selected below for
A5 or A6 and/or meets or below for A7 inelgible would appear.

All assistance is appreciated.