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
Last edited by romperstomper; 05-19-2011 at 02:19 AM.
Your formula looks right and when I tested it the result was as expected - "Location".
Are you sure you want " " as the result when not true. Usually the preferred result would be just "" (no space).
Same as Cutter. See attached.
ChemistB
My 2?
substitute commas with semi-colons if your region settings requires
Don't forget to mark threads as "Solved" (Edit First post>Advanced>Change Prefix)
If I helped, Don't forget to add to my reputation (click on the little star at bottom of this post)
Forum Rules: How to use code tags, mark a thread solved, and keep yourself out of trouble
Thanks- It worked.
Chris
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks