I have found this command:
=IF(ISERROR(SEARCH("x",A1)),"Z","")
How do you make mulitple arguements? I can't seem to get an =if(or(... function working.
Basically I have a cell with 5 if functions already and I need to add another arguement that if cell A doesn't have the text "Apple", "Banana", "Orange", "Carrot" or "Pear" then say "S", if not then say "".
that possible?
Many thanks
Mike
Try this...
Formula:
Please Login or Register to view this content.
If your problem is solved, then please mark the thread as SOLVED>>Above your first post>>Thread Tools>>
Mark your thread as Solved
If the suggestion helps you, then Click *below to Add Reputation
Please Login or Register to view this content.
-If the problem is solved, please mark your thread as Solved: Click Thread Tools above your first post, select "Mark your thread as Solved".
-Always upload a workbook before start your question
To attach a file, push the button with the paperclip (or scroll down to the Manage Attachments button), browse to the required file, and then push the Upload button.
+++ If my answer(s) helped you, please add me reputation by click on * +++
Try something like this...
=IF(SUMPRODUCT(--ISNUMBER(SEARCH({"Apple","Banana","Orange","Carrot","Pear"},A1))),"","S")
Last edited by AlphaFrog; 06-20-2013 at 02:49 AM. Reason: doesn't contain text
Hi All, Thanks for the repsonses. Unfortunately I am looking for a formula that answer "S" if the arguement is True. Not if it is false. Is that possible?
Cheers
Mike
Swap the "" with the "S" at the end of any of the IF formulasOriginally Posted by mikeop99
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks