G
Guest
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"),"Active","Inactive"))
Any ideas?
Thanks in advance
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"),"Active","Inactive"))
Any ideas?
Thanks in advance