FORMULA WITH A CELL THAT HAS A DATA VALIDATION LIST IN IT

[armymatt]

OK THIS IS WHAT I HAVE SO FAR:

=IF(AND(ISNUMBER(CP5:ED5)=TRUE),"COMPLETE","N/A")

IN CELL A5: CELL VALIDATION DROP DOWN LIST WITH 24 OPTIONAL "PERSONEL TITLES".

I NEED TO BE ABLE TO PUT THE FORUMAL IN CELL J5 SO THAT WHEN REQUIREMENTS
ARE MET IN (EE5:FD5) AND IF OPTIONS 5 AND BELOW ON THE DROP DOWN DATA LIST
IS TRUE THE DISPLAYED RESULT IS "COMPLETE"

AND IF WHEN REQUIREMENTS ARE NOT MET IN (EE5:FD5) AND OPTIONS 5 AND BELOW ON
THE DATA LIST DROP DOWN BOX ARE TRUE, THE DISPLAYED RESULTS IS "NOT COMPLETE".

AND IF WHEN OPTIONS 1,2,3, OR 4 ARE SELECTED THE DISPLAYED RESULTS IS "N/A"

 

[David Biddulph]

Come back to us when you've had your caps lock key repaired. Nobody will
listen while you're SHOUTING.

 

[armymatt]

Ummm.. Sorry, didn't realize thats what typing all Caps ment...

Ok this is what I have so far:

=IF(AND(ISNUMBER(CP5:ED5)=TRUE),"COMPLETE","N/A")

In Cell A5: I have a validation drop list with 24 optional “personnel titlesâ€.

I need to be able to put the formula in cell J5 so that when requirements
are met in (EE5:FD5) and if option 5 and below on the drop down data list are
true the displayed result is “Completeâ€

And if when requirements are NOT met in (EE5:FD5) and option 5 and below on
the data list drop down box are true, the displayed result is “Not Completeâ€

And if when options 1,2,3, or 4 are selected, the display result is “N/Aâ€