Would anyone know how to fix this problem? I want cell A676 to categorize based on info from 2 cells C676 and D676.

Basically IF the word "Paypal" is in cell D, AND there is a specific amount in cel C, I want it to categorize it in A676.

Thanks in advance!

Example image

  • Problem starts with multiple '=' signs, you should put just one at the beginning of the formula. Also brackets are messed up. Your formula should look like =IFERROR(IFS(AND(SEARCH("Paypal",D676)>0,C676=14),"Groceries", AND(SEARCH("Paypal",D676)>0,C676=45),"Internet", AND(SEARCH("Paypal",D676)>0,C676=21),"Telephone"),"-") – Oleg_S Sep 30 '20 at 8:21

You need to use IFS() with AND.

See the reference here:


Hi This is my code currently i.ibb.co/HTz1L0T/qsdf.png – Lloyd 14 mins ago

As outlined by OlegS you are still using multiple = signs in your code with the wrong syntax.

His comment that you should amend it to the following seems right in my view.

=IFERROR(IFS(AND(SEARCH("Paypal",D676)>0,C676=14),"Groceries", AND(SEARCH("Paypal",D676)>0,C676=45),"Internet", AND(SEARCH("Paypal",D676)>0,C676=21),"Telephone"),"-")
  • Hi, I still get the same problem. Can you please help out? What am I doing wrong? :( Would be great if someone could type out exactly what I need to write down – Lloyd Sep 30 '20 at 7:24
  • What did you try? I use this formula in one of my sheets and it works well... =IF(AND(C4="";D4="");W4;(C4+D4+G4+H4+K4+L4)). The critical thing is the placement of AND with the IF or IFS() as appropriate... – 24601 Sep 30 '20 at 8:05
  • 1
    @Lloyd again you have wrong syntax. =IFERROR(IFS(AND(SEARCH("Paypal",D676)>0,C676=14),"Groceries"),"-") Use formula in the answer. – Oleg_S Sep 30 '20 at 13:37
  • Thank you and really sorry guys, The formula works! But how do I add it to my existing formula...? :(( i.ibb.co/9vkwHCJ/qsdfzz.png – Lloyd Sep 30 '20 at 13:54
  • Please explain what you mean by add it to your existing formula? If the answer correctly addresses your issue issue please consider marking it as accepted which will assist others looking for a solution to the same or similar problem. Thank you. – 24601 Sep 30 '20 at 14:20

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.