Google-sheets – Google Sheets IF function

google sheets

I want to make a function with the following criteria:

if A2 is equal to A1 -> Text 1
if A2 is empty -> Text 2
if A2 is not empty and not equal to A1 -> Text 3

Something like connecting these two functions into one:

=if(A2=A1,"Text1","Text3")
=if(isblank(A2),"Text2")

Thanks for help in advance!

Best Answer

All you need to do is combine your two formulas:

=if(isblank(A2),"Text2",if(A2=A1,"Text1","Text3"))

Related Solutions

Google-sheets – Creating a function that runs when a Google spreadsheet is opened

This little script will:

create an extra menu item, thus making it accessible throughout the workbook. T
the menu item will set the active range to column E, last row + 1.

See the example I've prepared: Creating a function...Google spreadsheet is opened (edit rights)

function onOpen() {
  // get active spreadsheet
  var ss = SpreadsheetApp.getActiveSpreadsheet();

  // create menu
  var menu = [{name: "get last row", functionName: "getLastRow"}];

  // add to menu
  ss.addMenu("Rows", menu);  

  // execute function
  getLastRow();  
}

function getLastRow() {
  // get active spreadsheet
  var ss = SpreadsheetApp.getActive();

  // get active sheet
  var sh = ss.getActiveSheet();

  // get column F
  var indLastCol = sh.getLastColumn()-1;

  // get last row + 1
  var indRowWithout = sh.getLastRow()+1;

  // set new active range
  sh.setActiveCell('E'+indRowWithout);
}

Google Sheets – How to Incorporate SUBSTITUTE Function into Complex Functions

Short answer

=ARRAYFORMULA(
  SUBSTITUTE(
    IFERROR(
     REGEXEXTRACT(
      "|"&REGEXREPLACE(F2:F,"\n","|"),
      "^"&REPT("\|[^|]*",
      COLUMN(OFFSET(C1,,,1,5))-1)&"\|([^|]*)")
    ),
  "@","")
)

Explanation

The argument of the ARRAYFORMULA function, was included as the first argument of SUBSTITUTE and this was this was included as argument of the ARRAYFORMULA.

NOTE:

Breaklines and indents were included for readability. Google Sheets is able to handle this, but only will keep the breaklines and indents when an argument or function is changed. I recently added a more extended explanation on my answer to Pretty print google sheet formula?