Assessment Worksheet
 

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.

Assessment Worksheet
 

Yes, that's practicable. Define your criteria for eligible or ineligible,
and you can then write a formula for it.
You may wish also to test for blank inputs, and return a blank output until
the inputs have been completed.
You may also wish to use Data Validation to restrict the inputs to one of
your permitted values.

As with many questions, the difficulty is not in getting Excel to do what
you want. The main part of the job is for you to define what you want.

For your example, the formula might look like:
=IF(COUNTA(A5:A7)<3,"",IF(AND(OR(A5="meets",A5="ex ceeds"),OR(A6="meets",A6="exceeds"),A7="exceeds"), "eligible","ineligible"))
--
David Biddulph

"japc90" wrote in message
...
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.