Good Morning,
Trying to Combine If statement and a Mid statement in One Cell vs two separate cell.
Cell with text in it is D2--cell reads-- 001-012400-000-7010-000.
from this I used =mid(d2,5,6) returns 012400 - which was easy but I want IF that was true do this..
the if this true I want the formula to return the word "Location" if don't match then blank cell.
I wrote this - but doesn't work.
=If(MID(d2,5,6)="012400","Location"," ")
Any help would be great
thanks
Chris
Bookmarks