Google-sheets – IF Function with too many arguments

formulasgoogle sheetsregex

I want to apply this formula

=IF(A2= "", "", 
 IF(REGEXMATCH(A2, "Brand"), "Brand", 
 if(regexmatch(A2, "Loans"), "Loans" , 
 if(regexmatch(A2, "Cards"), "Credit Cards", 
 if(A2, "Generic"),"Generic", 
 if(REGEXMATCH(A2, "Generic"), "Generic", "Non-brand")))))

But it has more than 3 arguments.

Any idea on how I could make this work?

Best Answer

=IF(A2<>"", 
 IF(REGEXMATCH(A2, "Brand"), "Brand", 
 IF(REGEXMATCH(A2, "Loans"), "Loans" , 
 IF(REGEXMATCH(A2, "Cards"), "Credit Cards", 
 IF(A2="Generic", "Generic", 
 IF(REGEXMATCH(A2, "Generic"), "Generic", "Non-brand"))))), )

Related Solutions

Google-sheets – How to apply formula to multiple cells without it adjusting part of the formula

Prepend the column letter and/or row number that you don't want to change with $.

Let me illustrate:

Let's say in cell B2 I have this formula

=B1*A1

If I copy that to C2, what is pasted in C2 is

=C1*B1

But that's not what I want. I always want to multiply against A1. If, instead, B2 was

=B1*$A$1

Then when I copied to C2 I'd get

=C1*$A$1

If I pasted into Z99 I'd get

=Z98*$A$1

This includes using auto-fill.

If you only want one of the coordinates to stay "static", just put the $ before it. Like

=B1*$A1

Google-sheets – How to write an IF-formula with multiple OR/AND arguments to detect duplicates

Assuming that the first row is used for column headers, add the following formula to F2

=ArrayFormula(    
  IF(
    OR(
      COUNTIF($A$2:A&$B$2:B&$C$2:C,A2&B2&C2)>1,
      COUNTIF($A$2:A&$D$2:D&$E$2:E,A2&D2&E2)>1
    )
  ,1
  ,0
 )
)

Then fill down the above formula as necessary

Best Answer

Related Solutions

Google-sheets – How to apply formula to multiple cells without it adjusting part of the formula

Google-sheets – How to write an IF-formula with multiple OR/AND arguments to detect duplicates

Related Topic