Can anyone see what I am missing here? Your help is greatly appreciated.
Message received, "your formula is missing --) or (. Check the formula and then add the parenthesis in the appropriate place. The following is one long string. I broke it up to make it easier to read.
=IF(OR(ISNUMBER(FIND("J",M117)),K114,
OR(ISNUMBER(FIND("S",M117,)),K112,
OR(ISNUMBER(FIND("HOH",M117,)),K117,
OR(ISNUMBER(FIND("MF",M117)),K113,
OR(ISNUMBER(FIND("QW",M117)),K116,
OR(ISNUMBER(FIND("B",M117)),K115,0
Try changing the OR's to IF's...
=IF(ISNUMBER(FIND("J",M117)),K114,
IF(ISNUMBER(FIND("S",M117,)),K112,
IF(ISNUMBER(FIND("HOH",M117,)),K117,
IF(ISNUMBER(FIND("MF",M117)),K113,
IF(ISNUMBER(FIND("QW",M117)),K116,
IF(ISNUMBER(FIND("B",M117)),K115,0))))))
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, your changes worked. I'm not sure where the thread tool is located to mark this solved or the star. I must be blind today
Use "Thread Tools" towards the top of the screen (Just above your 1st post here)
To add rep points, click on the star on the botton left of any member's post (it says "add reputation")
I will add that if you have many more criteria to test, it may be better to look at a different approach, maybe vlookup and a small table
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks