0

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

Improve this question
1
  • 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, 2020 at 8:21

1 Answer 1

Reset to default
0

You need to use IFS() with AND.

See the reference here:

https://infoinspired.com/google-docs/spreadsheet/how-to-correctly-use-and-or-functions-with-ifs-in-google-sheets/

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"),"-")
Improve this answer
5
  • 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, 2020 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...
    – Low Rep Mods are bad
    Sep 30, 2020 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, 2020 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, 2020 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.
    – Low Rep Mods are bad
    Sep 30, 2020 at 14:20

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge that you have read and understand our privacy policy and code of conduct.

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