Google-sheets – How to make sure an equation doesn’t give an answer if more than one cell is blank

formulasgoogle sheetsgoogle-sheets-arrayformula

I have half the equation working:

=IF(AND(IF(NOT(ISBLANK(AG22)),TRUE,FALSE),AJ22<AG22),"1","0")

So it looks like this:

What I WANT it to do, is to only prompt an increase or decrease response if BOTH 90 and 180 days contain text. Right now, if 90 days is filled out but 180 is not, it gives a decrease. It shouldn't give any response unless 90 and 180 are BOTH filled out. So how do I nest another is not blank in there? Because it already stops it from answering if the row for 90 days is blank, but doesn't ALSO for 180. Does that make sense?

Here's a visual:

Help, please!

Best Answer

You can ask Sheets if both of the cells are not blank this way:

=IF(AND(NOT(ISBLANK(A2)),NOT(ISBLANK(B2))), "here","not here")

Related Solutions

Make Cell Flash onOpen Instead of onEdit in Google Sheets

The necessary changes are: replace onEdit with onOpen, and eliminate the check if( activeCell == "K2" ) as the script is no longer about the active cell.

I also shortened the script by replacing the inner conditional statement with a ternary operator.

function onOpen() {
  var ss = SpreadsheetApp.getActiveSpreadsheet();
  var mysheet = ss.getSheetByName("LBACC17");
  var cell = mysheet.getRange("K3");
  for (var i = 0; i < 50; i++) {
    cell.setBackground(i % 2 ? "WHITE" : "RED");
    SpreadsheetApp.flush();
    Utilities.sleep(500);
  }
}

Google-sheets – Formula result doesn’t show, leaves blank cell

Just had the same issue and it looks like it's just a bug that's easily fixed by reloading the page.

I had it on a document that I'd worked on in a previous browser session and all my existing formulas were fine but if I changed the inputs then the new results did not display. Also, any new formula failed to display results.

So it seems that for a particular browser session it fails to write formula results to the cell output.

Best Answer

Related Solutions

Make Cell Flash onOpen Instead of onEdit in Google Sheets

Google-sheets – Formula result doesn’t show, leaves blank cell

Related Topic