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)…

 

 

Related Posts
If Value is Greater Than A Certain Value
If Value is Greater Than A Certain Value 1

IF function is frequently used in Excel worksheet to return you expect “true value” or “false value” based on the logical test result. If you want to see if a value in one cell is greater than a specific value, ...

Excel IF Function With Dates
Excel IF Function With Dates4

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. You can use the IF function in ...

Excel IF function with text values
Excel IF function with Wildcards text value1

Normally, 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 check if a cell contains text(case-insensitive) By default, ...

Excel IF Function With Numbers
Excel IF Function Examples For Numbers3

Normally, If you want to write an IF formula for numbers in combining with the  logical operators in excel, such as: greater than, less than, greater than or equal to, less than or equal to, equal to, not equal to.etc. ...

Excel IF formula with NOT logical function
Excel formula using IF NOT function3

This post will guide you how to use excel if formula with NOT logical function in Microsoft excel. NOT Logical Function The syntax of NOT logical function is as follow: =NOT(logical_value) The NOT logical function will return the reversed logical ...

Excel IF formula with operator : greater than,less than
The Generic IF formula with Greater than operato5

This post will guide you how to use if function with “greater than”,  “greater than or equal to”, ”less than” and “less than or equal to” logical operators in excel. Greater than, Greater than or equal to, Less than, less than ...

Excel IF formula with AND & OR logical functions
Excel IF formula with AND OR logical functions2

If you want to test the result of cells based on several sets of multiple test conditions, you can use the IF function with the AND and OR functions at a time. Assuming that you have the following test logic to check ...

Excel IF formula with OR logical function
Excel formula using IF OR function1

This post will guide you how to use IF function combining with OR logical function in Excel. If you want to check if one of several conditions is met in your excel workbook, if the test is TRUE, then you ...

Excel IF formula with AND logical function

This post will guide you how to use IF function combining with AND logical function in Excel. If you want to check if a value in cell match two or more conditions at the same time, if the test is ...

Excel IF formula with “Equal to” logical operators
Excel IF formula with Equal to logical operators2

The “Equal to” logical operator can be used to compare the below data types, such as: text string, numbers, dates, Booleans.  This section will guide you how to use "equal to" logical operator in excel IF formula with text string ...

Sidebar