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.
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.