Hello,
Below is a function I am working on. Everything in my function works up to when I enter a link in P6. I do not know how to count links or hyperlinks but I was hoping the was someway that if P6 has http or www as a part of link then I would like my function to compute it and release the value I want to be entered. Any help will be appreciated. Thank you.
=+IF(AND(P6="Buy"),"Buy",IF(AND(P6="Instock"),"Instock ",IF(AND(P6="Supplier"),"Supplier",IF(AND(P6="www"),"Follow Link",""))))
It would help to see a sample of what you are working with?
Having said that, Im not sure you need all those AND()'s - AND() and OR() are used when you want to test for a number of different criteria. =AND(A1=1,B1=1) will give TRUE only if both A1 and B1 contain 1 =OR(A1=1,B1=1) will give TRUE if either A1 and B1 contain 1.
So may be try...
=IF(OR(P6="Buy",P6="Instock",P6="Supplier"),P6,IF(P6="www","Follow Link",""))
Not entirely sure what you mean the rest of your question?
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
Thank you for cleaning up my function. But it still does not work or do what I need it to do in reference to the counting the link. I have attached a sample ** my worksheet for you to see.Sample.xlsm
Try this, copied down
=IF(OR(B2={"Buy","Instock","Supplier"}),B2,IF(ISNUMBER(FIND("www",B2,1)),HYPERLINK(B2,"Follow Link"&B2),""))
That's awesome. It works. But can the function be edited only show "Follow Link" and not Follow Linkhttp://www.craigslist.org/about/sites
Thank you so much.
Sure, just remove the reference...
=IF(OR(B2={"Buy","Instock","Supplier"}),B2,IF(ISNUMBER(FIND("www",B2,1)),HYPERLINK(B2,"Follow Link"),""))
Happy to help and thanks for the feedback
Hi, I'm Cem /Jam/Originally Posted by FDibbins
Happy to help and thanks for the feedback
I don't have enough experience in excel.
Such that, I can't even figure out how to count all the hyperlinks in a specific range.
I searched, but It looks like the best solutions come from this forum.
Could you please help me?
Administrative Note:
Welcome to the forum.
We are happy to help, however whilst you feel your request is similar to this thread, experience has shown that things soon get confusing when answers refer to particular cells/ranges/sheets which are unique to your post and not relevant to the original.
Please see Forum Rule #4 about hijacking and start a new thread for your query.
If you are not familiar with how to start a new thread see the FAQ: How to start a new thread
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks