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")
  • Related: Return a blank when cell reference is blank Not a duplicate yet because, IMHO, the current answers with a score > 0 are wrong or too convoluted, by the other hand the other question involves the uso of ARRAYFORMULA while this one not. – Rubén May 2 '18 at 19:10

Short answer

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


  • ISBLANK checks is a cell is blank (completely empty)
  • IFS, IF and other similar functions returns blank when the corresponding argument is blank.
  • Works perfectly. Thank you so much!!! So, can you tell me how to change a simple subtraction function to also return a blank cell if either of the 2 cells is blank? – Barbara Sequin May 3 '18 at 12:01

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.