# IF AND ISNUMBER SEARCH Function. Keeps returning false value even if true.

1. ## IF AND ISNUMBER SEARCH Function. Keeps returning false value even if true.

Hello everyone,

I am trying to create a function for a spreadsheet at work, and my function continues to return the "false" value, even if it should be true. Below is the function I have so far:

``Please Login or Register  to view this content.``
What I would like is for the function to return the value true, if cell K contains any of the 3 numbers (810, 1050, or 1080). Is this a posibility? I have also tried K3=810,1050,1080, and that has not worked. Thank you in advance for the help.

Joshua Robbins

2. ## Re: IF AND ISNUMBER SEARCH Function. Keeps returning false value even if true.

Hi there. try this out:

=IF(AND(ISNUMBER(SEARCH("VA",J3)),OR(K3=810,K3=1050,K3=1080),(N3<=0)),"Increase","Needs Review")

3. ## Re: IF AND ISNUMBER SEARCH Function. Keeps returning false value even if true.

=if(or(k3=810,k3=1050,k3=1080),true,false)

4. ## Re: IF AND ISNUMBER SEARCH Function. Keeps returning false value even if true.

Alright, that seemed to work! So, I was separating the number values by commas only, when it should have been the entire cell value. That makes sense.

5. ## Re: IF AND ISNUMBER SEARCH Function. Keeps returning false value even if true.

Glad to have helped! If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. It'd also be appreciated if you were to click the add Reputation button at the foot of any of the posts of those who helped you reach a solution.

6. ## Re: IF AND ISNUMBER SEARCH Function. Keeps returning false value even if true.

Hello everyone,

I have come across an issue for the same function that I was typing earlier. Excel is now giving me an error that I've "entered too many arguments for this function". What does that mean, and is there an easy way to fix this? Below is my function.

``Please Login or Register  to view this content.``
Any help would be greatly appreciated.

7. ## Re: IF AND ISNUMBER SEARCH Function. Keeps returning false value even if true.

It means that you have the close parenthese in the wrong spot(s) For example,

=IF(ISNUMBER(Search(A1, B1), "Yes", "No"))
The ISNUMBER should only have 1 argument. In the formula above, it has 3; SEARCH(A1,B1), "Yes" and "No"
You need to match up your parentheses and see where one is misplaced.

8. ## Re: IF AND ISNUMBER SEARCH Function. Keeps returning false value even if true.

Alright, I see what you mean and I was able to make my correction. Now, if I would like to add this function to an existing macro, how would I convert it to the R1C1 format?

9. ## Re: IF AND ISNUMBER SEARCH Function. Keeps returning false value even if true.

I have a list of data that consist of narrative description of accidents. I am trying to search this data for specific words "rib", "face" and "longwall face." I have tried the =ISNUMBER(SEARCH(" rib "," &K4&""")) formula and the =IF(OR(K5="rib",K5="face",K5="longwall face"),TRUE,FALSE) and nothing works. These formulas return FALSE when the answer should be TRUE. Why? I have tried to paste the data as text and general format still I get FALSE as an answer. How can I correct this problem?

10. ## Re: IF AND ISNUMBER SEARCH Function. Keeps returning false value even if true.

Will you please attach a SMALL sample Excel workbook (10-20 rows of data is usually enough)? However, please give us an indication of the approximate number of rows of data you want the solution to work with (100, 1000, 100,000 or whatever). Please don't attach a picture of an Excel sheet (no-one will want to re-type all your stuff before starting).

1. It does NOT have to be your real sheet - mock up a SAMPLE if you need to. But not 1000's of rows!!! It makes manual checking so tedious. Whatever you do... make sure that all confidential information is removed first!!

2. Make sure that your sample data are truly REPRESENTATIVE of your real data. The use of unrepresentative data is very frustrating and can lead to long delays in reaching a solution.

3. Make sure that your desired solution is also shown (mock up the results manually).

4. Try to avoid using merged cells. They cause lots of problems!

Unfortunately the attachment icon doesn't work at the moment. So, to attach an Excel file you have to do the following: Just before posting, scroll down to Go Advanced and then scroll down to Manage Attachments. Now follow the instructions at the top of that screen.

There are currently 1 users browsing this thread. (0 members and 1 guests)