| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
testing for left 2 characters in set of 3 choices
following returns true even if false
a1=ab1234 b1=if(left A1,2)=or("cd","ef","gh"),1,2) test if A1=cd or ef or gh, true 1, false 2 the above should return 2 false but returns 1 true in error? I tried formula evaluation and it shows "ab"=false but then evalutes combined to true in error. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Get characters on left of specified character in Excel | Excel Discussion (Misc queries) | |||
| Find duplicates with left 4 characters | Excel Discussion (Misc queries) | |||
| Excel 2003, SUM left-most characters | Excel Worksheet Functions | |||
| Easiest way to extract characters in a cell LEFT or RIGHT of a sym | Excel Worksheet Functions | |||
| HOW DO I EXTRACT ALL CHARACTERS AFTER 5 CHARACTERS ON LEFT | Excel Worksheet Functions | |||
Threaded Mode
