Search code examples
excelexcel-2007

iferror and isblank in the same expression

How can I put isblank and iferror in the same expression. If a cell is blank or if it has an error in it, I should do something.

Thanks!

Solution

  • Here's an example formula.

    =IF(OR(ISERROR(C20),ISBLANK(C20)),"It is True", "It is False")

    Using OR allows you to use two logical checks in the same IF. Just make sure the value in your ISERROR and ISBLANK are the same.

    Replace C20 with what you are checking, and replace "It is True" with what you want to do, if it is blank or an error.