Hey Everyone,
I'm new here,
I want to do some commands,
I have an address coloumn at b2,
Then if b2 contains "manchester", c2 will be "UK"; if b2 contains "london", c2 will be "UK" too
but if b2 contains "roma", c2 will be "not UK"..
please anyone help..
thank you
Not clear about what you need, maybe better if you upload your sample workbook here, click "Go Advanced" button and find paperclip button to attach the file.
Salam
Rizky
Please Provide sample workbook with desire output
Thanks - Naveed
-----------------------------
If the suggestion helps you, then Click * to Add Reputation
To Attach File: Go Advanced>>Manage Attachments>>Add Files (In Top Right Corner)>>SelectFiles>>.........Locate Your File(s)>>Upload Files>>Done (In Bottom Right)
1. Use [code] code tags [\code]. It keeps posts clean, easy-to-read, and maintains VBA formatting.
2. If you are happy with a solution to your problem, mark the thread as [SOLVED] using the tools at the top.
Try the below,
=IF(OR(B2="Manchester",B2="London"),"Uk",IF(B2="Roma","Not Uk","Na"))
Else pl post a sample
☚ Click ★ just below left if it helps, Boo?ath?
Try the below,
=IF(OR(B2="Manchester",B2="London"),"Uk",IF(B2="Roma","Not Uk","Na"))
Else pl post a sample
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks