| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
if(or(left Formula
Hi, I am trying to write a "combination" IF formula that will look at the
first 4 characters in a cell (in total in a cell there are 8 characters) and if they equal "A123" or "A234" - a result will display in another cell. I was trying this =IF(Or(LEFT(D2,4)="A123",(LEFT(D2,4)="A234"),"Acti ve","Inactive")) Any ideas? Thanks in advance |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| LEFT &RIGHT formula on the same cell | Excel Discussion (Misc queries) | |||
| Array Formula - using LEFT("text",4) in formula | Excel Worksheet Functions | |||
| Question about using the right or left formula | Excel Discussion (Misc queries) | |||
| How to change the right-to-left worksheet to left-to-right workshe | Excel Discussion (Misc queries) | |||
| LEFT formula doesn't works.. | Excel Worksheet Functions | |||
Threaded Mode
