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

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"

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

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

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

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

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€�


"David Biddulph" wrote:

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

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