Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Test for Single Character That is in an Array
Cell D116 on my worksheet contains the character "C".
Another cell on the worksheet contains the (non-working) test: =IF(D116 LIKE "A..L", "yes", "no") This doesn't work. I want it to return "yes" because the character "C" is in the array "A..L" but I can't figure out how to do this. I could accomplish this using VB, but would rather use a worksheet function. |
#2
|
|||
|
|||
Hi
one way =IF(D116=CHAR(65),IF(D116<=CHAR(76),"yes","no")," no") Cheers JulieD "scallyte" wrote in message m... Cell D116 on my worksheet contains the character "C". Another cell on the worksheet contains the (non-working) test: =IF(D116 LIKE "A..L", "yes", "no") This doesn't work. I want it to return "yes" because the character "C" is in the array "A..L" but I can't figure out how to do this. I could accomplish this using VB, but would rather use a worksheet function. |
#3
|
|||
|
|||
Hi
maybe try: =IF(AND(CODE(D116)=CODE("A"),CODE(D116)<=CODE("L" )),"yes","no") -- Regards Frank Kabel Frankfurt, Germany "scallyte" schrieb im Newsbeitrag m... Cell D116 on my worksheet contains the character "C". Another cell on the worksheet contains the (non-working) test: =IF(D116 LIKE "A..L", "yes", "no") This doesn't work. I want it to return "yes" because the character "C" is in the array "A..L" but I can't figure out how to do this. I could accomplish this using VB, but would rather use a worksheet function. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Working with array equations | Excel Discussion (Misc queries) | |||
Transpose into a _working_ transposed array | Excel Discussion (Misc queries) | |||
Removing ' character from cells | Excel Discussion (Misc queries) | |||
VBA Import of text file & Array parsing of that data | Excel Discussion (Misc queries) | |||
Keeping Array values? | Excel Worksheet Functions |