Google-sheets – Returning a blank cell when there is no data

google sheets

I want to change this function so that if AR4 is blank then the corresponding cell is also blank. Right now it is saying DNP. The function I am using is

=IFS(AR4>445, "P", AR4<446, "DNP")

Best Answer

Short answer

=IFS(ISBLANK(AR4),,AR4>445, "P", AR4<446, "DNP")

Explanation

  • ISBLANK checks is a cell is blank (completely empty)
  • IFS, IF and other similar functions returns blank when the corresponding argument is blank.