1

How do I change a simple subtraction function =B3-A3 to return a blank cell if either of the 2 cells is blank?

1

Short answer

=IF(OR(ISBLANK(B3),ISBLANK(A3)),"A3 or B3 are blank",B3-A3)

Explanation

  • Use ISBLANK to test if cell is blank
  • Use OR to check if any of its arguments is true
  • Use IF to return something if the condition returns true and other thing if the condition returns false

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.