ISNUMBER(SEARCH) for multiple values, too many commands

[ttianna]

I want to use ISNUMBER and SEARCH to return specific values if certain values are found in another cell, but I have too many.

=IF(ISNUMBER(SEARCH("assessment",D4)),"Graded",IF(ISNUMBER(SEARCH("Aplia",D4)),"Graded",IF(ISNUMBER(SEARCH("Other",D4),"Not Graded"))))

I want it to return "Graded" if it finds "Assessment" or "Aplia", and "Not Graded" if it finds "Other", and a FALSE return if it doesn't find any of those terms.

What I get now with this formula is an error that says:
"You've entered too many arguments for this function."

I tried using an OR command to nest further, but that didn't work either.

 

[jasonb75]

You had misplaced paranthesis, try

=IF(ISNUMBER(SEARCH("assessment",D4)),"Graded",IF(ISNUMBER(SEARCH("Aplia",D4)),"Graded",IF(ISNUMBER(SEARCH("Other",D4)),"Not Graded")))

 

[ttianna]

Awesome! Thank you!

 

[Scott Huish]

=IF(COUNT(SEARCH({"assessment","Aplia"},D4)),"Graded",IF(ISNUMBER(SEARCH("other",D4)),"Not Graded"))

 

[T. Valko]

I want to use ISNUMBER and SEARCH to return specific values if certain values are found in another cell, but I have too many.

=IF(ISNUMBER(SEARCH("assessment",D4)),"Graded",IF(ISNUMBER(SEARCH("Aplia",D4)),"Graded",IF(ISNUMBER(SEARCH("Other",D4),"Not Graded"))))

I want it to return "Graded" if it finds "Assessment" or "Aplia", and "Not Graded" if it finds "Other", and a FALSE return if it doesn't find any of those terms.

What I get now with this formula is an error that says:
"You've entered too many arguments for this function."

I tried using an OR command to nest further, but that didn't work either.

Here's another one...

=IF(SUM(COUNTIF(D4,"*"&{"assessment","Aplia"}&"*")),"Graded",IF(COUNTIF(D4,"*Other*"),"Not Graded"))

 

[SatishN]

Im trying similar formula..

but it does not give desired output.

=IF(ISNUMBER(SEARCH("ERef",AV3)),"Ref",ISNUMBER(SEARCH("eEdu",AV3)),"Edu",ISNUMBER(SEARCH("eEV",AV3)),"EV","")))

 

[SatishN]

Got it thanks..

 

[hershy3]

Got it thanks..

I Tried this and its not working

=IF(ISNUMBER(SEARCH("posit",K9)),"Deposit",IF(ISNUMBER(SEARCH("Lance",K9),"Balance",1))

 

[Scott Huish]

Your parentheses aren't correct:

=IF(ISNUMBER(SEARCH("posit",K9)),"Deposit",IF(ISNUMBER(SEARCH("Lance",K9)),"Balance",1))

 

[John_Roqua]

Hi, I need a favor for this formula where I don't need return value to be "FALSE". I used this:

=IF(ISNUMBER(SEARCH("PETROL",C6)),"TRANSPORT"," ",IF(ISNUMBER(SEARCH("TRANSPORT",C6)),"TRANSPORT"," ",IF(ISNUMBER(SEARCH("HARDWARE",C6)),"HARDWARE"," ")))

But it returns the error message "Too many arguments were entered for this function".Please help.