In Google Sheets, how do I keep a cell blank based on two other cells' contents?

Question

I want to create a function that subtracts two cells from each other but stays blank if either of those cells are blank.

So far I have this: =IF(ISBLANK(R9)," ",R9-Q9) This works when R9 is blank. The problem is I need the ISBLANK function to reference Q9 AND R9, but I can only input one argument for that type of function.

Answer 1

Try this

 =IF(OR(ISBLANK(R9),ISBLANK(Q9)),,R9-Q9)

• Uses OR function.
• The second argument of the IF function is empty, instead of returning a TEXT with one space. This way, the cell having the formula will be BLANK if R9 or Q9 are BLANK.