Search code examples
if-statementgoogle-sheetsnestedformula

How to combine IFS and AND formula in Google Sheets?

I have three columns (A,B,C) with multiple rows of data, some of the cells will have a text and some will be blank. In my fourth column I am trying to create a formula that returns a value once a certain combination of the text in columns A,B,C is identified.

I started off with the below formula but I get stuck once I am trying the following logic "if cell B2 says ABC AND cell C2 says CBA then return 100".

=IFS(A2="ABC","100",B2="ABC","50",C2="ABC","50",AND(B2="ABC",C2="CBA","100"))

Could you please help me?

Solution

  • Slightly rearranging your parameters within ifs() to:

    =IFS(A2="ABC","100",
     AND(B2="ABC",C2="CBA"),"100",
     B2="ABC","50",
     C2="ABC","50",
     1,"--")