Excel IF function check if the cell is blank or not-blank

If you want to check the value in one cell if it is blank or empty cell, then you can use IF function in combination with ISBLANK function or logical operator (equal to) in excel.

Excel IF function check if the cell is blank

Let’s see the generic IF formula with ISBLANK function and Logical operator = as follows:

=IF(ISBLANK(B1),"PASS","FAILED")
=IF(B1="","PASS","FAILED")

In the above two IF formulas, it will return “PASS” if Cell B1 is blank, Otherwise returns “FAILED”.

Excel IF function check if the cell is blank or not-blank1

Excel IF function check if the cell is non-blank

If you want to check the value in one cell if it is not blank or not empty cell, then you can use IF function in combination with ISBLANK function or logical operator (not equal to) in excel.

let’s see the generic IF formula with ISBLANK function and Logical operator <> as follows:

=IF(ISBLANK(B1)=FALSE,"PASS","FAILED")
=IF(B1<>"","PASS","FAILED")

In the above two IF formulas, it will return “PASS” if Cell B1 is not blank, otherwise returns “FAILED”.

Excel IF function check if the cell is blank or not-blank1

Let’s write a nested if function in combining with AND function and ISBLANK function to achieve the following test criteria.

IF cell A1 is greater than or equal to 10, then add to C1.

If Cell B1 is greather than or equal to 10, then subtract from C1.

If both A1 and b1 are blank cells, then equals to C1.

Based on the above logic, we can write down the following excel nested if formula (statement):

=IF(A1>=0,C1+A1, IF(B1>=0,C1-B1, IF(AND(ISBLANK(A1)=TRUE, ISBLANK(B1)=TRUE),C1,"")))

Excel IF function check if the cell is blank or not-blank1


Related Formulas

  • Excel IF formula with operator : greater than,less than
    Now we can use the above logical test with greater than operator. Let’s see the below generic if formula with greater than operator:=IF(A1>10,”excelhow.net”,”google”) …

  • Excel IF function with text values
    If you want to write an IF formula for text values in combining with the below two logical operators in excel, such as: “equal to” or “not equal to”…
  • Excel IF Function With Numbers
    If you want to check if a cell values is between two values or checking for the range of numbers or multiple values in cells, at this time, we need to use AND or OR logical function in combination with the logical operator and IF function…
  • Excel IF function with Dates 
    If you have a list of dates and then want to compare to these dates with a specified date to check if those dates is greater than or less than that specified date. …

Related Functions

  • Excel AND function
    The Excel AND function returns TRUE if all of arguments are TRUE, and it returns FALSE if any of arguments are FALSE.The syntax of the AND function is as below:= AND (condition1,[condition2],…) …
  • Excel IF function 
    The Excel IF function perform a logical test to return one value if the condition is TRUE and return another value if the condition is FALSE….
  • Excel nested if function
    The nested IF function is formed by multiple if statements within one Excel if function. This excel nested if statement makes it possible for a single formula to take multiple actions…
  • Excel ISBLANK function
    The Excel ISBLANK function returns TRUE if the value is blank or null.The syntax of the ISBLANK function is as below:= ISBLANK (value)…

 

 

Leave a Reply