| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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" |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Data Validation - In cell drop Down List | Excel Discussion (Misc queries) | |||
| How do you create a list & data validation in same cell? | Excel Worksheet Functions | |||
| Deleting formula in data validation list | Excel Worksheet Functions | |||
| Help required - Data - Validation - List - Formula | New Users to Excel | |||
| HELP: Data > Validation ---List ----Formula | Excel Worksheet Functions | |||
Threaded Mode
